User Guide

Contents v
Creating Table Joins........................................................................................................................40
Building Flexible Search Interfaces...............................................................................................40
Code Review ............................................................................................................................41
Returning Query Results to the User.............................................................................................42
Chapter 5: Making Variables Dynamic .........................................................45
Dynamically Populating Select Boxes...........................................................................................46
Creating Dynamic Checkboxes and Multiple Select Boxes.........................................................47
Checkboxes..............................................................................................................................47
Multiple select lists..................................................................................................................49
Testing for a variable’s existence...................................................................................................51
Creating Default Variables with CFPARAM ..................................................................................51
Checking Query Parameters with CFQUERYPARAM ..................................................................52
Dynamic SQL...................................................................................................................................53
Chapter 6: Updating Your Data.....................................................................59
Inserting Data..................................................................................................................................60
Creating an HTML Insert Form .....................................................................................................60
Data Entry Form Notes and Considerations.........................................................................61
Creating an Action Page to Insert Data.........................................................................................61
Updating Data.................................................................................................................................62
Creating an Update Form ..............................................................................................................63
Creating an Action Page to Update Data ......................................................................................65
Deleting Data ..................................................................................................................................66
Requiring Users to Enter Values in Form Fields...........................................................................67
Validating the Data That Users Enter in Form Fields ..................................................................68
Chapter 7: Reusing Code ...............................................................................71
Ways to Reuse Code........................................................................................................................72
Reusing Common Code with CFINCLUDE ..................................................................................72
About Custom Tags in CFML.........................................................................................................73
Using Existing Custom Tags...........................................................................................................73
Writing Custom CFML Tags...........................................................................................................73
Passing Attribute Values between Custom Tags ..........................................................................74
Nesting Custom Tags......................................................................................................................77
Passing Data Between Nested Custom Tags ................................................................................78
What data is accessible?..........................................................................................................78
Where is data accessible?........................................................................................................78
High-level data exchange .......................................................................................................78
Passing Custom Tag Arguments via CFML Structures.........................................................81
Executing Custom Tags..................................................................................................................82
Tag instance data.....................................................................................................................82
Pattern of execution................................................................................................................83
Modes of execution.................................................................................................................83
Specifying execution modes...................................................................................................83
Terminating tag execution .....................................................................................................84