Programming instructions

80 Lesson 2 Writing Your First ColdFusion Application
Summary
This lesson described how to access a relational database using ColdFusion. You used the
SQL SELECT statement and the
cfquery and cfoutput tags to display trip lists. You
built a search tool that dynamically builds a WHERE clause of the SQL SELECT
statement using
cfif and cfset tags. To ensure that the SQL statement remains intact,
you used the
PreserveSingleQuotes CFML function.
In the next lesson
In the next lesson, you will build the main navigation page for the Trip Maintenance
application. This page will display detail information about the currently selected trip.
Additionally, it will provide buttons to do trip maintenance and browsing through the
trips table. You will also link the trip search facility that you built in this lesson to the
main page that you will build in the next.