ColdFusion 8

Introduction
Welcome
Course Topics
Course Prerequisites
Software Requirements/Installation

The Role of ColdFusion
Client-Server Environment
Static vs. Dynamic Requests
What is ColdFusion?
Why Use ColdFusion?
ColdFusion Editors

Course Setup
Installing Dreamweaver
Dreamweaver Preferences
Installing ColdFusion
Testing the Setup
Installing the Course Files
Installing the Course Database
Dreamweaver CF Tags

Introducing Dreamweaver
Dreamweaver Interface
Set Up the Course Site
Set Up Testing Server
Application Panel
Browser Setup
Code Navigator
Related Files Toolbar

ColdFusion Fundamentals
ColdFusion Templates
What is a Variable?
Set/Display Variables
Commenting Code
Processing Flow
CF Includes
Creating Header & Footer
Build Template Page

Expressions
Variable Types
Datatypes
Expressions
Operators
Functions
Lists

CF Functions
Function Definitions
Calling a Function
Common Functions
List Functions
Custom Functions

URL Variables
HTML Statelessness
URL Variables
Working with URL Variables
Dynamic URL Variables

CFML Conditionals/Loops
Conditional Processing
If Statements
Testing for Variables
Switch Statements
What is a Looping Statement?
CF Looping
Index Loops
List Loops
Nested Loops

Databases
Relational Databases
Connection Basics
Review Course Database

Basic SQL Statements
SELECT Statement Syntax
INSERT Statement Syntax
UPDATE Statement Syntax
DELETE Statement Syntax
INNER JOIN
SQL Wildcard

Creating Data-Driven Pages
CFQUERY Tag
Recordset Builder
Display a Query
Use Query Data
Using Query Variables
CFDUMP
Dynamic Table Feature
Recordset Paging
Navigation Bar
Debugging Queries

ColdFusion Forms
Form Basics
Form Methods
HTML Form pt. 1
HTML Form pt. 2
SUMA Form
Add Fields
Processing Forms
Fields Not Submitted

Form Data Validation
Form Validation
Client Side JavaScript
Redirecting the User
Server-Side Validation pt. 1
Server-Side Validation pt. 2

ColdFusion Forms
CFFORM Tag
CFINPUT/CFTEXTAREA
SUMA Form
CFSELECT
Combine Static Options
Preserving Form Data

Modifying Database Data
Inserting Data
CFINSERT
Form with CFINSERT
Updating Data
CFUPDATE
Update Interface
Deleting Data

Search Criteria
Multiple Search
Search Form
Search Action

Form to E-mail
The Process
CFMAIL
E-mail from Forms

Debugging/Troubleshooting
Troubleshooting
Debugging Techniques
Preventing Problems

Closing
Additional Resources
ColdFusion Hosting

Credits
About the Author