Contents > Getting Started Building ColdFusion MX Applications > Lesson 6: Adding and Updating SQL Data > Completing the Trip Maintenance application

Completing the Trip Maintenance application

In Lesson 5: Implementing the Browsing and Maintenance Database Functions, you created the tripeditaction.cfm page to contain server side edits for the trip edit data entry form. In this final lesson, you will complete the tripeditaction.cfm page. To complete the action page, you will write code to do these tasks:

• Add trips to the Compass Travel database using the cfquery tag and the SQL INSERT statement.
• Add trips to the Compass Travel database using the cfinsert tag.
• Update the current trip using the cfupdate tag.
• Link the current trip to be updated or added by the tripeditaction.cfm with the tripedit.cfm page.

In addition to completing the Trip Maintenance application, you will develop a ColdFusion page to update all the prices in the database using the cfquery tag and the SQL UPDATE statement.

Contents > Getting Started Building ColdFusion MX Applications > Lesson 6: Adding and Updating SQL Data > Completing 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.