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

Q&A

Q1:How many questions can this query handle?
A1: You could add as many questions to this recordset as your SQL server can handle in a single query. Unfortunately, UltraDev seems to have some problems with lengthy queries. In fact, the query used here confused the SQL entry field when I first entered it. Hopefully this will be corrected in a future version of UltraDev.
Q2:What sorts of applications can this be used with?
A2: Anything. Although today's lesson used the search technique to match people, 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 have selected. If that information wasn't important, we could make due 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