MACROMEDIA COLDFUSION 4.5-DEVELOPING WEB, Develop Manual

Page: 5 / 380

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