System information

Summary 69
3. Save both the triplisting.cfm file and the gettrips.cfc file.
4. View the triplisting.cfm page in a browser and verify that all the new requirements were met.
The revised TripListing.cfm page looks like this:
The dates and prices in the preceding listing are not formatted. In “Lesson 6: Creating a Main
Application Page” on page 97, you will enhance the look of this page.
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 also learned to
use ColdFusion components to write structured, reusable code.
In the next lesson
In the next lesson, you will build the search form to let users select which information to retrieve.
To build the query based on what the user enters in the search form, you will use dynamic SQL.
You will then display the results of the search on an action page.