Introduction to ColdFusion

• Static Client/Server Model on the web
• Dynamic Client/Server Model using ColdFusion

Web-to-Database Integration

• JDBC data sources, drivers, and SQL
• ODBC data source names (DSNs)
• Cold Fusion Web to Database Integration Model

Writing ColdFusion Code

• ColdFusion templates
• Using HomeSite+
• Viewing/Editing files in Homesite+
• Using Dreamweaver
• Viewing/Editing files in Dreamweaver
• Executing files in a web browser
• Writing HTML tags

Accessing the Date and Time

• Date functions and formats
• Time functions and formats

Working with Variables

• Setting variables with <cfset>
• Displaying variable values with <cfoutput>

Passing Variables Between Pages

• Passing variables via links or via forms
• Distinguishing among variable types

Building Forms with Homesite+

• Creating form elements

Conditionals in ColdFusion

• <cfif> and <cfelse> conditionals
• ColdFusion conditional operators
• Using <cfif> and <cfelse> to perform form validation
• <cfabort> and form validation
• Adding <cfelseif> blocks to a condititonal
• Self-submitting forms

An Introduction to SQL

• Database concepts and SQL syntax
• Issuing database commands with SQL
• Retrieving information with SELECT
• Inserting a row in a table with INSERT
• Editing records with UPDATE
• Delete records with DELETE

Querying a Database

• <cfquery> and <cfoutput> tags
• Distinguishing query variables
• Counting records with queryname.recordcount

Displaying Query Records in Table Format

• Creating HTML tables manually
• Creating HTML tables with the <cftable> tag

Dynamically Populating Select Lists

• Dynamically populating a select list via <cfoutput>
• Auto-populating select lists with <cfselect>

Creating a Search Interface

• Using the LIKE clause
• Using % and _ in a LIKE statement
• Building dynamic SQL statements

Implementing Basic Data Drill-Downs

• Explanation of drill-down code
• Passing variables between pages
• Passing variables via links

The <cfqueryparam> Tag

• Protection against SQL injection attacks

Inserting Records into the Database

• Inserting a record into a database table
• Inserting a work of art into the artworks table
• Hidden fields to pass data in a form submission
• <cfinsert> tag

The <cflocation> Tag

• Redirecting the user
• Where and how <cflocation> is used
• isdefined() function

The <cfinclude> Tag

• What are server-side includes?
• ColdFusion options for include files
• Working with the <cfinclude> tag

Form Validation

• Client-side and server-side

Editing Records in the Database

• Building an editing application to edit works of art
• Using the <input> tag's value attribute
• UPDATE page and <cfupdate> tag
• Passing the primary key
• "Deleting" without deleting

Generating Email Messages with <cfmail>

Output Shortcuts

• The <cfdump> tag

Encapsulating Data Using Sessions

• The Basics of encapsulation
• Encapsulating session data
• Encapsulating a component within a session
• Outline of a component
• Accessing a component in session scope
• Removing the component from the session
• Advantages of encapsulation

ColdFusion Administrator Configuration

• Accessing the administrator to set up data sources
• Setting the mail server connection

ColdFusion Variable Types

Working with Cookies

• What is a cookie?
• Why do some consider cookies bad?
• Implementation characteristics set by user agent

Working with Sessions

• What is a session?
• When does the session end?
• Configuring and enabling session variables
• Enabling session variables in your application
• Storing session data in session variables
• Standard session variables
• Getting a list of session variables
• Creating and deleting session variables
• Life cycle of a ColdFusion template
• Uses for application.cfm
• Session and application variables
• Required CFAPPLICATION tag
• Locking session/application variables with CFLOCK
• Password protection with sessions

Debugging Advice