| Getting Started Building ColdFusion MX Applications |
|
|
Implementing the Browsing and Maintenance Database Functions |
|
| Getting Started Building ColdFusion MX Applications |
|
|
Implementing the Browsing and Maintenance Database Functions |
|
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.
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.