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.
Содержание COLFUSION MX 7-GETTING STARTED BUILDING COLDFUSION...
Страница 1: ...COLDFUSION MX7 Getting Started Building ColdFusion MX Applications...
Страница 6: ...6 Contents...
Страница 10: ......
Страница 14: ...14 Chapter 1 Introducing ColdFusion MX...
Страница 38: ...38 Chapter 3 Database Fundamentals...
Страница 40: ......
Страница 58: ...58 Chapter 5 Lesson 2 Configuring Your Development Environment...
Страница 70: ...70 Chapter 6 Lesson 3 Retrieving Data...
Страница 84: ...84 Chapter 7 Lesson 4 Building Dynamic Queries...
Страница 96: ...96 Chapter 8 Lesson 5 Creating a Trip Detail Page...
Страница 102: ...102 Chapter 9 Lesson 6 Creating a Main Application Page...