System information

128 Chapter 11: Lesson 8: Implementing Browsing and Searching

Reviewing the code

The following table describes the code that executes when the user clicks the Search button:

Summary

In this lesson, you added the capability of browsing trips sequentially to the Trip Detail page. You

also limited the result set of the dynamic query using the

MaxRows attribute of the cfquery tag.

By implementing the Maintenance Action page, you enabled users to take action on the current

trip. You used the ColdFusion

cflocation tag to link the search page to the Trip Detail page.

In the next lesson

You have implemented the navigation buttons and the Search button on the Trip Detail page. In

“Lesson 9: Enabling Database Maintenance” on page 129, you will implement the Delete, Add

and Edit buttons.

Code Explanation

<cflocation url=

"tripsearchform.cfm">

If the Form.btnSearch variable exists

because the user clicked the Search

button, go to the page

tripsearchform.cfm.