User Guide

117
CHAPTER 10
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.