System information

59
CHAPTER 6
Lesson 3: Retrieving Data
In this lesson, you begin the construction of a Macromedia ColdFusion web application for the
fictitious company, Compass Travel. The exercises in this lesson introduce you to the process of
retrieving data from the Compass Travel relational database.
This lesson contains the following exercises:
Exercise 1: About the trip list . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60
Exercise 2: Retrieving the information for the trip list . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
Exercise 3: Displaying the query result using the cfoutput tag . . . . . . . . . . . . . . . . . . . . . . . . . 62
Exercise 4: Writing structured, reusable code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Exercise 5: Creating additional queries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66