Programming instructions

128 Lesson 5 Implementing the Browsing and Maintenance Database Functions
Summary
In this lesson, you converted the Trip Detail page from the search result display into a
trip browser by using
cfquery with SQL SELECT. The browser enables users to navigate
sequentially through the Trips table. 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. Additionally, you used
cfquery and SQL DELETE to delete the current
trip.
In the next lesson
You have implemented two of the four maintenance buttons on the Trip Detail page. In
the next lesson, you will implement the Add and Edit buttons. Because these functions
require user input, you will build a new page, tripedit.cfm, to capture this information.
The user input must be validated against the Compass Travel business rules before the
data is saved to the database. Therefore, in the next lesson, you also will implement the
business rule validation. In the final lesson, you will add the database update logic.