Building Truly Dynamic Statements

No sooner do you roll out your movie search screen at Orange Whip Studios, but you immediately find yourself inundated with requests. “Searching by title is great, but what about searching by tag line or rating?” your users ask. Now that you have introduced the ability to search for data, your users want to be able to search on several fields.

Adding fields to your search screen is simple enough. Add two fields: one for tag line and one for rating. The code for the updated search screen is shown in Listing 12.15.

Listing 12.15. search2.cfm—Movie Search Screen
<!--- Name: search2.cfm Author: Ben Forta (ben@forta.com) Description: Creating search screens Created: 07/01/07 ---> <html> <head> <title>Orange Whip Studios ...

Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.