• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 12. Building Search Interfaces > What You Have Learned

What You Have Learned

In this lesson, you have:

  • Prepared tours.asp so that it can accommodate three different kinds of search (pages 292–294)

  • Built a dynamic menu that sends data to tour_detail.asp using dynamically generated URL variables (pages 295–298)

  • Replicated that dynamic menu on another page (page 299)

  • Used code commenting as a strategy for testing and debugging isolated pieces of code (pages 300–302)

  • Built a form with a menu populated with dynamic data (pages 302–305)

  • Displayed or hid the Recordset Navigation Bar based on the number of records returned in a query (pages 306–308)

  • Written an SQL query that filters data joined into two tables based on the value of a URL variable, and another that filters using a form variable (pages 309–312)

  • Written an SQL query that uses the EXISTS keyword and a subquery (pages 313–314)

  • Dynamically switched SQL queries based on the presence or absence of environmental variables using nested if…else structures in conjunction with IsEmpty() (ASP) and IsDefined() (ColdFusion) (pages 315–318)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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