Contents > Getting Started Building ColdFusion MX Applications > Lesson 5: Implementing the Browsing and Maintenance Database Functions > Enhancing the Trip Maintenance application

Enhancing the Trip Maintenance application

In this lesson, you will make enhancements to the sample Trip Maintenance application that you created in previous lessons. In Lesson 4: Validating Data to Enforce Business Rules, you added buttons to the Trip Detail page to browse, add, edit, delete or search for records in the database. In this lesson you will build the action pages that implement the actions for these buttons.

Page flow

You will combine the Trip Detail page and the search pages you built in the previous lessons with a maintenance action page and a navigation action page you will build in this lesson. In the final two lessons you will build a Trip Edit page to complete the trip maintenance facility. The following figure shows the flow of the finished Trip Maintenance application pages:

Notice that the Trip Detail page is at the center of the Trip Maintenance application. Depending on the user action, the Trip Detail page navigates the records in the database or connects to the appropriate page to add, edit, delete, or search for records in the database.

In order for the application to process the user actions from the Trip Detail page, you must build the two action pages for the navigation and maintenance functions.

Navigation action page

This navigation action page determines which triprecord displays on the Trip Detail page after the user presses one of the navigation buttons. There is no HTML output displayed from this action page. Instead, this page uses dynamic SQL to identify the tripID that must display on the Trip Detail page. In this dynamic SQL statement the proper tripID is passed as a parameter to the URL then redirects it to the Trip Detail page.

Maintenance action page

The maintenance action page processes a user's maintenance request from the Trip Detail page. The request can be any of the following actions:

• Delete the currently displayed trip.
• Launch the search facility.
• Add a new trip (implemented in the previous two lessons).
• Update the currently displayed trip (implemented in the previous two lessons).

Contents > Getting Started Building ColdFusion MX Applications > Lesson 5: Implementing the Browsing and Maintenance Database Functions > Enhancing the Trip Maintenance application

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/browse_2.htm

Add Comment