Programming instructions

119
LESSON 5
Implementing the Browsing and
Maintenance Database Functions
In this lesson, you will enhance the Compass Travel ColdFusion application by providing
code to implement the navigation and maintenance database functions.
This lesson explains how to do the following tasks:
• Use SQL SELECT to move to the first, last, next and previous rows in the trips table
• Add code to the main application page to browse the trips table
• Use SQL DELETE to delete rows in the trips table
• Use cflocation to link the search facility built Lesson 1 to the main Trip
Maintenance application page.
ColdFusion tags and functions introduced in this lesson
The following table identifies the ColdFusion tag and structure that you use in this lesson
to enhance the Trip Maintenance application:
Element Type Brief description
cflocation Tag Opens a ColdFusion page or HTML file.
URL Structure Structure to hold the variables within a URL.