ColdFusion Training : Core ColdFusion 9

Core ColdFusion 9

ColdFusion Training Course Duration

3 Days

ColdFusion Training Course Outline

Part 1: Introduction to ColdFusion

Part 2: ColdFusion Basics

Using CFML
- Code Editors
- Dreamweaver Interface.
- Tag Updaters / Extensions
- Tag Editing Dialog Boxes
Embedded Tag Help
Using ColdFusion Comments
Creating Variables
- <cfset> and <cfoutput>
Variable Scope/Prefixes.
Built-in ColdFusion Functions
- CF Function Reference (Dreamweaver specific)
- Online Reference (http://livedocs.adobe.com)
- Tip: (http://cfquickdocs.com)
Demo: Built-in Functions
Demo: Date / Time Functions
Using <cfinclude> to reuse code
- Demo: Create Header and Footer with <cfinclude>
Exercise 1: Build Dynamic Page Footer using Variables and Date Functions
- Challenge
Possible Solution to Exercise 1

Part 3: Dynamic Data: Querying the Database

Database Basics
Introduction to SQL
- Select Statement
- Update Statement
- Insert Statement
- Delete Statement
Data Source Name (DSN) / Remote Development Server (RDS)
- The DSN Used in This Class: movieList
- Course Project Database
Querying the database with <cfquery>
- <cfdump> for Quick Output
Exercise 2: Query the database
- Challenge
Possible Solution to Exercise 2
Customizing Display with <cfoutput>
- Demo: Using <cfoutput>
- Building Dynamic Tables
- Shortcut: <cftable>
- Shortcut: Dynamic Table Tool (in Dreamweaver)
Exercise 3: Display Resulting Records manually with <foutput>
- Challenge
Possible Solution to Exercise 3

Part 4: Creating a Drill-down Interface

Part 5: Conditional Statements and Forms

Conditional Statements
- <cfif>, <cfelseif> and <cfelse>
Comparison Operators
- Operator
- Description
Demo: Conditional Statements
Demo: Conditional Statements Using URL Variables
- Using the isDefined() function
Exercise 5: Conditional Statements � Data Validation
- Challenge
Possible Solution to Exercise 5
HTML Form Review
- Demo: Pass Variable through a Form
Exercise 6: Process Form Submission
- Challenge
Possible Solution to Exercise 6
Self-Submitting Forms
- Using the <cfparam> tag to set a default value
- Quick Examination of a ColdFusion Framework (Methodology): Fusebox
Exercise 7: Self-submitting Form
- Challenge
Possible Solution to Exercise 7
Dynamically Populating Select Lists
- HTML Review:<select> tags
- Demo: Dynamic Select List
Exercise 8: Create a Dynamic Select List
- Challenge
Possible Solution to Exercise 8

Part 6: Quick Introduction to RSS and Ajax with

Reading an RSS Feed
- Demo: Consuming an RSS Feed
- Demo: Creating an RSS Feed
Introducing the
Tag
- Building a Mask with <cfform>
- Automatically Build a Dynamic Select List with <cfselect>
- Demo: Creating an Auto Suggest Text Field with <cfform>

Part 7: Search Interface

Creating a Search Interfacei
- Demo: Using the LIKE clause
- Using % and _ in a LIKE Statement
- Demo: Building Dynamic SQL Statements
Exercise 9: Create a Search Interface
- Note
- Challenge
Possible Solution to Exercise 9

Part 8: Insert Records into the Database.

SQL Insert Statement
- Demo: Insert Record Part 1 � the Form
- Insert Record Part 2 � the Insert
Shortcut: <cfinsert>
Redirect Users with <cflocation>
Exercise 10: Insert a New Actor in the Database
- Challenge
Possible Solution to Exercise 10
Automated Form Validation
- Client-side vs. Server-side validation: When does the validation code run?
Exercise 11: Automatic Client-side (or Server-side) Form Validation.
- Challenge
Possible Solution to Exercise 11

Part 9: Edit (Update) Database Records

SQL UPDATE Statement Review
- Demo: Update Record Page 1 � select the record to edit
- Passing the Primary Key.
- Page 2 � View Current Data in a Form.
- Page 3 � Perform the Update to the Database
Shortcut:
Exercise 12: Edit a Record
- Challenge
Note on Deleting records
- Review of the SQL Delete Statement
- �Deleting� without deleting
- No <cfdelete>!

Part 10: Reusing Code

Reusing code with <cfinclude> and <cflocation>
Custom Tags
- Demo: custom tags
- Where to store Custom Tags
- Demo: Custom Tag with Parameters
- CALLER and ATTRIBUTE scopes
Using <cfmodule>
A Note about CFX tags
Exercise 13: Calling a Custom Tag to Display a List of Years.
- Challenge
Possible Solution to Exercise 13

User Defined Functions (UDFs) and ColdFusion Components (cfcs)

Part 11: Using Session Variables for Password Protection

Session Variables
- Creating Password Protected Pages
- The Included Page: demo-password-protect.cfm
- The Log in Page: demo-password-form.cfm
Application.cfc
Note regarding Application.cfm
Locking Session and Application variables with <cflock>
Exercise 15: Password Protecting Pages (optional)
- Challenge
Possible Solution to Exercise 15

Part 12: Tracking User Information with Cookies (optional)

Part 13: Sending email with <cfmail> (optional)

Appendix A: Resources
Appendix B: Set-up Notes
Appendix C: Create a Dreamweaver �Site�

Location of our course files
Site Creation � Basic
- The Advanced Tab � Additional Categories
Site Files Panel
- �Create a Site� vs. �FTP or RDS Server Connection�

Appendix D: Selecting Among ColdFusion Code Reuse Methods