Getting Started Building ColdFusion MX Applications

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:

Element	Type	Description
cfinsert	Tag	Inserts records in a JDBC data source.
cfupdate	Tag	Updates a records in a JDBC data source.

Copyright © 2002, Macromedia Inc. All rights reserved.

Comments