| Getting Started Building ColdFusion MX Applications |
|
|
Writing Your First ColdFusion Application |
|
| Getting Started Building ColdFusion MX Applications |
|
|
Writing Your First ColdFusion Application |
|
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, 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.