MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuel d'instructions télécharger pdf (Page 89)

Developing a search capability 79

4 Verify that the price and departureDate are now considered in the query, as in step

4 in the previous exercise:

a Open the tripsearch.cfm page in the my_app directory in your browser.

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.

c Click the Search button.

Now, because the departure date is considered in the query, there are no rows

returned.

Note: If you planned to use many more fields as search criteria, the approach used to

add departure date and price criteria to the Trip Search form is not the most elegant

solution. A generic routine to handle WHERE clause string construction based on

specific data types could reduce the code and be a more extensible solution then the

one presented here. This more extensible approach is beyond the scope of this tutorial,

however.

1 2 ... 84 85 86 87 88 89 90 91 92 93 94 ... 153 154

Pas de commentaire

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manuel d'instructions Page 89