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.
Summary of Contents for COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION...
Page 1: ...COLDFUSION MX7 Getting Started Building ColdFusion MX Applications...
Page 6: ...6 Contents...
Page 10: ......
Page 14: ...14 Chapter 1 Introducing ColdFusion MX...
Page 38: ...38 Chapter 3 Database Fundamentals...
Page 40: ......
Page 58: ...58 Chapter 5 Lesson 2 Configuring Your Development Environment...
Page 70: ...70 Chapter 6 Lesson 3 Retrieving Data...
Page 84: ...84 Chapter 7 Lesson 4 Building Dynamic Queries...
Page 96: ...96 Chapter 8 Lesson 5 Creating a Trip Detail Page...
Page 102: ...102 Chapter 9 Lesson 6 Creating a Main Application Page...