ColdFusion Training Course

• A familiarity with Web terminology
• An understanding of Web server characteristics
• Experience with the HTML tag set and syntax
• Familiarity with the SQL command set, including SELECT, INSERT, UPDATE, and DELETE

Introducing ColdFusion

• Advantages of dynamic web pages
• Using ColdFusion Markup Language (CFML)
• ColdFusion Components and Features
• Configuring ColdFusion environments
• Creating a site with Dreamweaver MX 2004
• Creating local variables with
• Referencing variables
• Displaying variable values using
• Including files using the tag
• Creating comments

Publishing Database Content

• Understanding Relational Databases
• Using Database Drivers to connect to data sources
• Understanding the tag
• ColdFusion Administrator debugging
• Using to display database data
• Using the Dynamic Table Tool
• Additional information returned with queries
• Using ColdFusion Functions

Building Forms with ColdFusion

• Understanding HTML forms and form controls
• Enabling debug output
• Self-Posting forms
• Determining form submission with and IsDefined()
• Evaluating form variables
• The tag
• Converting to ColdFusion forms
• Using

Building Search Interfaces

• Using form data in dynamic queries
• Preserving form data
• Creating dynamic SQL
• Using multiple search criteria
• Creating a dynamic SQL statement
• Using text searches
• Using list searches

Building a Drill-Down Interface

• Using Dynamic URL parameters
• Creating a Query String
• Dynamic URL Parameters
• Creating a data drill-down
• Data drill-down page

Inserting New Data

• Building an Insert FORM Page
• Using ColdFusion Validation
• Using Client-side Validation
• Using Server-side Validation
• Creating Custom validation
• Building Insert ACTION Logic
• Using with INSERT
• Redirecting Process Flow with the tag

Updating Data

• Building an Update FORM Page
• Providing the primary key for update
• Pre-Filling HTML Forms
• Building Update Logic with

Reusing Templates

• Reusing Code
• Using Custom Tags
• Using User-Defined Functions
• Finding UDFs
• ColdFusion Components
• Finding CFCs

Securing an Application

• Using the ColdFusion Login Wizard
• Understanding the Login Pages
• Customizing the Login
• Using the Application Framework
• Using Application Events
• Using Application Variables
• Using Session Variables