Programming instructions

129
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.