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

Summary

Today's lesson covers one of the most powerful tools that you have at your disposal—UltraDev's authentication system and your database server! The UltraDev authentication behaviors greatly speed up the process of developing protected sites, while the database makes it possible to perform minor miracles by creating advanced SQL queries.

The query system that you've just developed is useful, but it is also limited because it places equal emphasis on all the queries. You can refine the process that we've created today by adding weights to the various elements of the query. Additionally, traditional search elements can be used to limit the recordset to values that are exact matches. For example, rather than matching all the records, you could modify the query in the WHERE clause. If people wanted exact matches based on smoking preferences, this comparison would be moved out of the absolute value calculation into the WHERE portion of the SQL.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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