Getting Started Building ColdFusion MX Applications

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 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.

Copyright © 2002, Macromedia Inc. All rights reserved.

Comments