• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. ColdFusion Forms > Creating Dynamic SQL Statements

Creating Dynamic SQL Statements

Now that you're familiar with forms and how ColdFusion processes them, you can return to creating a movie search screen. The first screen enables visitors to search for a movie by title. Because this requires text input, you will need an <INPUT> field of type text. The field name can be anything you want, but using the same name as the table column to which you're comparing the value is generally a good idea.

TIP

When you're creating search screens, you can name your form fields with any descriptive name you want. When you're creating insert and update forms, however, the field name must match the table column names so ColdFusion knows which field to save with each column. For this reason, you should get into the habit of always naming form fields with the appropriate table column name.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint