Now that you’ve seen how dynamic SQL is used, let’s return to data drill-down pages. The first screen you need to create is the details page—the one that will be displayed when a movie is selected. Figure 10.14 shows the details for one movie.
Listing 10.12 contains the code for the file details1.cfm. Save the code, and then execute it in your browser with this URL:
You should see a screen like the one in Figure 10.14 ...