System information

Contents 5
CHAPTER 11: Lesson 8: Implementing Browsing and Searching . . . . . . . . . . . . 123
Exercise 1: Enabling users to browse trip details . . . . . . . . . . . . . . . . . . . . . . . . . 123
Exercise 2: Determining actions based on which button a user clicks. . . . . . . . . . 127
Exercise 3: Enabling searching from the Trip Detail page . . . . . . . . . . . . . . . . . . 127
Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128
CHAPTER 12: Lesson 9: Enabling Database Maintenance . . . . . . . . . . . . . . . . 129
Exercise 1: Deleting the current trip record shown on the Trip Detail page . . . . . 129
Exercise 2: Adding trips with SQL INSERT statements . . . . . . . . . . . . . . . . . . . 131
Exercise 3: Adding data using the cfinsert tag . . . . . . . . . . . . . . . . . . . . . . . . . . . 135
Exercise 4: Updating a SQL row using the cfupdate tag. . . . . . . . . . . . . . . . . . . . 137
Exercise 5: Linking the Trip Edit page to the main page . . . . . . . . . . . . . . . . . . . 138
Exercise 6: Inserting values in the edit form. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139
CHAPTER 13: Lesson 10: Restricting Access to ColdFusion Applications . . . . 143
Exercise 1: About the Login Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143
Exercise 2: Requiring users to log in to the Compass Travel application. . . . . . . . 147
Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149