![]() ![]() ![]() |
||
|
When designing the search criteria page, it is a good idea to develop a list of possible queries that the user might issue when searching for the records. Most Compass Travel customers are primarily concerned with trip locations, departure dates, and price; the following is a list of the types of queries that the agents are likely to require at Compass Travel:
There are a number of considerations to take into account when you design a search page to capture the users search criteria. The following are two of the most important considerations:
In this exercise, the Compass Travel trip coordinator searches the trips based on tripLocation, departureDate, and price. Because these columns are the only ones that users can query, they are the only ones contained in the WHERE clause of the generated SQL statement. In addition, the coordinator has no control over which columns are returned in the record set. The query always returns the same columns to identify a trip:
In later exercises, you will reference these columns when you build the SQL SELECT statement for the cfquery
in the search action page.
|
||
![]() ![]() ![]() |