Programming instructions

68 Lesson 2 Writing Your First ColdFusion Application
3 Create the Budget Trip List report by doing the following:
a Modify the SQL SELECT statement, as follows:
SELECT tripName, departureDate, returnDate, price
FROM trips
WHERE price <= 1500
ORDER BY tripName
b Change the heading tag from <h1>Trip List</h1> to <h1>Budget Trip
List</h1>.
4 View the triplisting.cfm in a browser and verify that all the new requirements were
met. The revised TripListing.cfm page looks like this:
Note that the dates and prices in the preceding listing are not formatted. In Lesson 3
you will enhance the look of this page.