![]() |
||
|
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
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. |
|
||
![]() |