Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

Using a Database

Back to the example. At this point, you have determined that a film database will make your job easier and might even help preserve your sanity. You create a table with columns for movie title, tag line, release date, and the rest of the required data. You enter your movie list into the table, one row at a time, and are careful to put the correct data in each column.

Next, you instruct the database application to sort the list by movie title. The list is sorted in a second or less, and you print it out. Impressed, you try additional sorts—by rating and by budgeted amount.

You now have two or more lists, but you had to enter the information only once; because you were careful to break the records into multiple columns, you can ...