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.

Version 7

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/7/htmldocs/00000172.htm