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

Workshop

The Workshop area is meant to reinforce your reading with a series of questions and exercises.

Q&A

Q1: How many questions can this query handle?
A1: You can add as many questions to this recordset as your SQL server can handle in a single query. Unfortunately, Dreamweaver MX seems to have some problems with extremely lengthy queries.
Q2:What sorts of applications can this be used with?
A2: Anything. Although today's lesson used the search technique to match dogs, you can use it anywhere. For example, you could provide attribute rankings for products in a shopping catalog that could be queried. Essentially, anywhere you have a search, you could consider using this technique.
Q3:Do I have to set up the separate option tables all the time?
A3: These tables are only needed because we wanted to display the names of the options that the users selected. If that information wasn't important, we could make do with just the tblUserInfo table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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