System information

134 Chapter 12: Lesson 9: Enabling Database Maintenance
To test the modified code:
1. Open the tripedit.cfm page in your browser.
2. In the tripedit.cfm page, enter in the fields the values in the following table, and then click Save.
After the new trip is written to the database, the following message appears: You have added
NH White Mountains to the trips database.
3. To verify that the trip was saved, open the tripsearchform.cfm page in the my_app directory in
your browser.
4. In the Trip Search page, in the Trip Location drop-down list, select the Begins With option,
and enter the value Nor in the text box.
5. Click Search.
The TripResults page appears.
6. Click NH White Mountains to display the details of the trip you just added. Verify that all the
fields were saved correctly.
7. Click the Delete button to delete this record so that you can reuse some of the steps of this
exercise in Exercise 3: Adding data using the cfinsert tag.
Field Value
Trip Name NH White Mountains
Event Type Mountain Climbing
Trip Description Climb the 5 highest peaks in the New Hampshire White Mountains.
Trip Location Northeastern New Hampshire
Departs 05/01/2005
Returns 05/10/2005
Number of People 15
Price 1200
Base Cost 600
Deposit Required Yes
Trip Leader Tom Finn
Photo File Name whitemountains.jpg