Contents > Getting Started Building ColdFusion MX Applications > Lesson 5: Implementing the Browsing and Maintenance Database Functions

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 in Lesson 2: Writing Your First ColdFusion Application 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.

Contents > Getting Started Building ColdFusion MX Applications > Lesson 5: Implementing the Browsing and Maintenance Database Functions

ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.