Contents > Getting Started Building ColdFusion MX Applications > Lesson 6: Adding and Updating SQL Data

Lesson 6: Adding and Updating SQL Data

In this lesson, you will complete the Compass Travel Trip Maintenance application. The exercises will guide you through the steps of adding the database update logic to add new trip offerings and update existing trips in the Compass Travel database.

This lesson explains how to do the following tasks:

• Modify the Trip Edit page to link the add and update functions to the main application page.
• Write code to insert new trips using SQL.
• Write code to insert new trips without using SQL.
• Write code to update several records in the Trips table.

ColdFusion tags and functions introduced in this lesson

The following table identifies the ColdFusion tags and functions that you use in this lesson to enhance the ColdFusion application:

cfinsert

cfupdate

Contents > Getting Started Building ColdFusion MX Applications > Lesson 6: Adding and Updating SQL Data

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.