Programming instructions

Developing a search capability 77

The Trip Results page displays several entries as follows:

c Notice in the Trip Results page that only one trip has a trip location of China.

d Click the Back button in your browser to return to the Trip Search page.

3 In the Trip Location drop-down list box of the Trip Search page, select the Is option,

enter the value China, then click Search.

The Trip Results page displays only one entry for the trip to China in the HTML

table.

4 Verify that the other criteria (departure date and price) are not taken into

consideration yet as follows:

a Click the Back button in the browser to return to the Trip Search page.

b In the Departure Date drop-down list box, select Before, enter 1/1/1900 as the

date, and select Smaller Than 0 for the price.

Obviously, either of these conditions would produce a results page with no rows.

c Click the Search button.

The Search Result page should be identical to Step 3 because the code to build

the WHERE clause in the Trip Results page does not include departure date and

price.

Exercise: enabling the departure and price criteria on the Trip Search form

In this exercise you will modify the Trip Search Results page to add the criteria needed for

the departure and price query.

To enable the departure and price criteria:

1 In an editor, open the tripsearchresult.cfm page in the my_app directory, then locate

the following comment line: