MACROMEDIA COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION..., Начало работы

Страница: 71 / 152

71
CHAPTER 7
Lesson 4: Building Dynamic Queries
In this lesson, you develop a search form to allow users to select the information to retrieve, and
then display, the search results.
This lesson contains the following exercises:
Exercise 1: Creating the trip search form . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Exercise 2: Building a query that uses dynamic SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
Exercise 3: Constructing the initial Trip Search Results page . . . . . . . . . . . . . . . . . . . . . . . . . . 79
Exercise 4: Testing the Trip Search Results page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
Exercise 5: Enabling the departure and price criteria on the Trip Search form . . . . . . . . . . . . . 82
Exercise 6: Testing the revised Trip Search Results page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
Exercise 1: Creating the trip search form
As you recall from “Lesson 1: Preparing to Build the Sample Application” on page 41 , two of the
requirements for the Trip Maintenance application are the ability to generate trip listings and a
trip query facility. You will create a search interface that meets both of these requirements in this
exercise.
About the trip search form
The dynamic listings that you developed in “Lesson 3: Retrieving Data” meet many of Compass
Travel’s requirements for locating trips. However, what if the number of trips were in the
thousands or tens of thousands? Locating the right trip for a customer might be difficult and
certainly time consuming. Moreover, it is very hard, if not impossible, to anticipate all the ways
that a user might want to search for trips.