• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Complex Searches

As you build Web sites that collect user information, you'll discover that providing searching features for the databases is a necessity. SQL, by its very nature, provides an excellent system for querying tables of information. Unfortunately, what if the user wants to search the system based on parameters outside a direct SQL query? Even worse, what if the search needs to match some items but not all of them?

For example, consider a search on a database of used cars. The user is searching for a car that is a convertible and is blue, but he wouldn't mind purple—if there isn't any purple, black would be fine. That sort of logic is very difficult to represent in a search that isn't directly written for the user making the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint