List of Tables

Chapter 2: Overview of CFML

Table 2.1: Common CFML Tags and Their Functions

Table 2.2: Scope Types

Table 2.3: Operators in ColdFusion

Table 2.4: Common Mathematical Functions

Table 2.5: Common String Functions

Table 2.6: Common Date and Time Functions

Table 2.7: Common Array Functions

Table 2.8: Common List Functions

Table 2.9: Common Formatting Functions

Table 2.10: Types of Loops

Chapter 4: Form Handling using ColdFusion MX

Table 4.1: Types of Data Used with POST

Table 4.2: <CFHTTPPARAM> Attributes

Table 4.3: <CFFORM> Controls

Chapter 5: Accessing Databases using ColdFusion MX

Table 5.1: Common SQL Verbs

Table 5.2: Common Statement Clauses

Table 5.3: Common SQL Operators

Table 5.4: Query Properties

Chapter 7: Integrating ColdFusion MX with Other Platforms

Table 7.1: Conversion of Java to ColdFusion Datatypes

Chapter 8: Using the ColdFusion MX Code Compatibility

Table 8.1: Structure of the Users Table

Table 8.2: Structure of the Query Table

Table 8.3: Limitations of the Settings Migration Wizard

Table 8.4: Modified Tags and Attributes

Table 8.5: Locales and Their Currency Formats

Chapter 9: Project Case Study—Upgrading the Existing ColdFusion 5.0 Application

Table 9.1: Field Names and Their Datatypes In the Users Table

Table 9.2: Field Names and Their Datatypes in the Query Table

Chapter 10: Upgrading the ColdFusion 5.0 Application to a ColdFusion MX Application

Table 10.1: Properties Assigned to the Form Control

Table 10.2: Properties Assigned to the Text Field Controls

Table 10.3: Properties Assigned to the Button Control

Table 10.4: Properties Assigned to the Text Field and TextArea Controls

Table 10.5: Properties Assigned to the Button Control

Chapter 11: Using the <cffile> Tag to Upload a File

Table 11.1: File Upload Attributes

Chapter 13: Creating the Knowledge Bank Application

Table 13.1: Properties Assigned to the Form Control

Table 13.2: Properties Assigned to the Text Field Controls

Table 13.3: Properties Assigned to the Button Control

Table 13.4: Properties Assigned to the Text Field Controls

Table 13.5: Properties Assigned to the List Controls

Table 13.6: Properties Assigned to the File Control

Table 13.7: Properties Assigned to the Button Control

Table 13.8: Properties Assigned to the List Controls

Table 13.9: Properties Assigned to the Button Control

Table 13.10: Properties Assigned to the Text Field Controls

Table 13.11: Properties Assigned to the List Controls

Table 13.12: Properties Assigned to the List Controls

Table 13.13: Properties Assigned to the Button Controls

Table 13.14: Properties Assigned to the Checkbox Control

Table 13.15: Properties Assigned to the Button Control

Table 13.16: Properties Assigned to the Attributes of the <CFDIRECTORY> Tag

Chapter 14: Handling Errors and Exceptions using ColdFusion MX

Table 14.1: List of <cferror> Tag Variables

Chapter 16: Creating the Recruitment System Application

Table 16.1: Properties Assigned to the Form Control

Table 16.2: Properties Assigned to the Text Field Controls

Table 16.3: Properties Assigned to the Button Control

Table 16.4: Properties Assigned to the Text Field Controls

Table 16.5: Properties Assigned to the Checkbox Control

Table 16.6: Properties Assigned to the List Control

Table 16.7: Properties Assigned to the Button Control

Table 16.8: Properties Assigned to the Text Field Controls

Table 16.9: Properties Assigned to the List Control

Table 16.10: Properties Assigned to the Button Control

Table 16.11: Properties Assigned to the Text Field Controls

Table 16.12: Properties Assigned to the List Controls

Table 16.13: Properties Assigned to the Button Control

Chapter 17: Introduction to ColdFusion Components

Table 17.1: Differences Between Custom Tags and CFCs

Chapter 19: Creating the Online Appraisal Application

Table 19.1: Properties Assigned to the Form Control

Table 19.2: Properties Assigned to the List Controls

Table 19.3: Properties Assigned to the Button Control

Table 19.4: Properties Assigned to the Text Field Control

Table 19.5: Properties Assigned to the List Control

Table 19.6: Properties Assigned to the Button Controls

Table 19.7: Properties Assigned to the Text Field Controls

Table 19.8: Properties Assigned to the List Controls

Table 19.9: Properties Assigned to the Button Controls

Table 19.10: Properties Assigned to the Text Field Control

Table 19.11: Properties Assigned to the Check Box Control

Table 19.12: Properties Assigned to the Button Control

Table 19.13: Properties Assigned to the Text Field Controls

Table 19.14: Properties Assigned to the List Control

Table 19.15: Properties Assigned to the Button Control

Chapter 20: Understanding the Verity Search Engine

Table 20.1: Sample Data

Chapter 22: Creating the Worldwide Search Application

Table 22.1: Properties Assigned to the Form Controls

Table 22.2: Properties Assigned to the Text Field Control

Table 22.3: Properties Assigned to the List Controls

Table 22.4: Properties Assigned to the Button Controls

Table 22.5: Properties Assigned to the Text Field Controls

Table 22.6: Properties Assigned to the List Controls

Table 22.7: Properties Assigned to the Button Control

Table 22.8: Properties Assigned to the Text Field Controls

Table 22.9: Properties Assigned to the List Controls

Table 22.10: Properties Assigned to the Button Control

Table 22.11: Properties Assigned to the List Control

Table 22.12: Properties Assigned to the Text Field Control

Table 22.13: Properties Assigned to the Checkbox Control

Table 22.14: Properties Assigned to the Button Control

Table 22.15: Properties Assigned to the List Control

Table 22.16: Properties Assigned to the Text Field Control

Table 22.17: Properties Assigned to the Checkbox Control

Table 22.18: Properties Assigned to the Button Control

Chapter 23: Working with XML Data Using ColdFusion MX

Table 23.1: Directories and Their Purpose

Table 23.2: Predefined Entities in XML

Table 23.3: XML DOM Objects

Chapter 25: Creating the Purchase Management Application

Table 25.1: Properties Assigned to the Form Control

Table 25.2: Properties Assigned to the Text Field Control

Table 25.3: Properties Assigned to the List Control

Table 25.4: Properties Assigned to the Button Control

Table 25.5: Properties Assigned to the Form Control

Table 25.6: Properties Assigned to the Hidden Field Control

Table 25.7: Properties Assigned to the Button Control

Table 25.8: Properties Assigned to the Form Control

Table 25.9: Properties Assigned to the Hidden Field Control

Table 25.10: Properties Assigned to the Button Control

Chapter 26: Drawing Charts

Table 26.1: Sample Data for the tblParameters Table

Table 26.2: Attributes of the <cfchart> Tag

Table 26.3: Attributes of the <cfchartseries> Tag

Table 26.4: Attributes of the <cfchartdata> Tag

Chapter 27: E-Mail Integration with ColdFusion MX

Table 27.1: The <cfmail> Tag Attributes

Table 27.2: The <cfpop> Tag's Attributes

Table 27.3: Query Fields

Chapter 29: Creating the Sales Data Analyst Tool

Table 29.1: Properties Assigned to the Chart Control

Table 29.2: Properties Assigned to the Chart Series

Table 29.3: Properties Assigned to the Chart Control

Table 29.4: Properties Assigned to the Chart Series

Table 29.5: Properties Assigned to the Chart Control

Table 29.6: Properties Assigned to the Chart Series

Table 29.7: Properties Assigned to the Form Control

Table 29.8: Properties Assigned to the Text Area Control

Table 29.9: Properties Assigned to the Button Control

Table 29.10: Properties Assigned to the Hidden Control

Appendix A: Creating ColdFusion MX Custom Tags

Table A.1: Variables In the thisTag Structure

Appendix B: Scripting with the <cfscript> Tag

Table B.1: Common CFScript Statements

Appendix C: Using Java Objects in ColdFusion MX

Table C.1: Objects That Can Be Created Using the <cfobject> Tag

Table C.2: Properties in the Employee Class

Table C.3: Methods in the Employee Class

Appendix E: Introduction to Microsoft .NET

Table E.1: Namespaces in the .NET Framework Class Library