Lesson 9: Enabling Database Maintenance

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

This lesson contains the following exercises:

Exercise 1: Deleting the current trip record shown on the Trip Detail page

Exercise 2: Adding trips with SQL INSERT statements

Exercise 3: Adding data using the cfinsert tag

Exercise 4: Updating a SQL row using the cfupdate tag

Exercise 5: Linking the Trip Edit page to the main page

Exercise 6: Inserting values in the edit form

ColdFusion tags introduced in this lesson

The following table identifies the ColdFusion tags 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 records in a JDBC data source.