ColdFusion Training : Core ColdFusion 9

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

Passing Variables between Pages
“Two-page method"
Demo: Pass Variables via Links
- Demo: List of Actors with links
Receive Variables through the URL
- Using a WHERE clause in a SQL Statement
Protecting Against SQL Injection Attacks with
Exercise 4: Drill-down for More Detail
- Challenge
Possible Solution to Exercise 4

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)

Creating UDFs with the <cffunction> tag
Using ColdFusion Components (CFCs)
- Creating Components
- Calling or Invoking Components
- Passing Arguments to Components
- The Component Code
- The main CFML page
- View a Component directly in the browser
Exercise 14: UDFs
- Challenge
Possible Solution to Exercise 14

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)

Demo: setting cookies
Exercise 16: Remember Users by using Cookies
- Challenge
Possible Solution to Exercise 16

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

Using ColdFusion to Send Email
- <cfmail> Tag Syntax
- Demo: Sending an email
Exercise 17: Sending Automated Emails
Possible Solution to Exercise 17

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
Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved