Introduction

• Course Introduction
• Set-up course files and data sources (DSNs)
• Charting and graphing options

The <cfchart> Tag

• Using <cfchart> vs. <cfchartseries>
• Linking from a chart to another page
• <cfchartdata> to manually add data
• Caching charts
• Saving charts for future use with <cffile>
• Creating a chart with <cfchart>

Application Framework

• Application.cfm and onRequestEnd.cfm
• New application framework: Application.cfc
• Storing application variables
• Using application variables

Manipulating Complex Data Objects

• Scalar Variables
• Lists
• Arrays
• Structures

The <cfloop> Tag

• Looping with <cfloop>
• Syntax of <cfloop>
• Weeding out the FIELDNAMES variable
• Using <cfloop> for automatic query output
• Displaying results with <cfloop>

Creating Queries of Queries

CFCs: Building ColdFusion Components

• Benefits to using CFCs
• Creating components
• Calling or invoking components
• Passing arguments to components
• The main CFML page
• Three ways to pass arguments
• Where to save CFCs
• Viewing a component directly in the browser

Object-Oriented CFCs

• Object-oriented principles
• CFC using Object-Oriented Model
• Using CFC vs. other OO languages
• Inheritance
• Access control
• Exposing CFCs as web services
• Building OOP CFC with parameters

Errors and Exceptions

• Standard error handling
• The error page
• Detailed error page
• Structured error handling
• <cftry> and <cfcatch>
• Transactions with <cftransaction> and <cftry>
• Using <cftransaction> to avoid errors

The <cfscript> Tag

• Limited capabilities of <cfscript>
• Syntax rules
• Reserved words
• Looping with <cfscript>
• Setting variables with <cfscript>
• Using GetTickCount() to test speed

Custom Tags

• About custom tags
• Where to store custom tags
• Custom tags with parameters
• CALLER and ATTRIBUTE scopes
• <cfmodule>
• Using Custom Tags

Stored Procedures

• Benefits of stored procedures
• Passing a parameter to a stored procedure

Showing Portions of a Recordset

• Paging through records
• Adding "Next" and "Previous" links

Flash Forms

• Flash form basics
• Using masks
• Automatic form validation
• Binding data
• Using <cfgrid> and flash forms

Scaling Applications

• Focus on performance and salability
• Caching queries and pages

The <cffile> Tag

• Reading and writing text files with <cffile>
• Building a simple message board
• Uploading documents with <cffile>
• Dynamically creating static html pages
• Form tag additions
• Saving long variable values with <cfsavecontent>
• Uploading external files
• Using <cfdirectory>

The <cfhttp> Tag

• Making http requests with <cfhttp>
• Using <cfhttp> to display a complete page
• Using <cfhttp> to download a complete page
• Attributes of <cfhttp>
• Converting a text file into a query with <cfhttp>
• While looping though the records…
• Adding a column to a query
• Using <cfhttp> to access and parse external data
• Passing variables with <cfhttp> and <cfhttpparam>
• Creating an intelligent agent
• Simulating the post method with <cfhttp>

Web Services

• Creating WSDL documents
• Converting CFCs into web services
• SOAP
• Security
• xml parser
• Invoking external web services
• Locating web services
• Invoking .NET web services
• Consuming internal and external web services
• Dreamweaver, web services and components

Using XML

• xml syntax review
• Logical structure and physical structure
• xml logic: designing datasheets
• Parsing xml data with ColdFusion
• Using XMLParse()
• Referring to specific xml nodes
• Looping through each node with <cfloop>
• Counting child nodes

Loading XML Data

• Accessing xml data with <cffile>
• Building xml objects in .cfm document with <cfxml>
• Using queries to build xml Document Object
• Manipulating xml data with built-in functions
• Structure/Array functions
• xml specific functions
• Add nodes to xml Document Object
• Create query object from existing xml
• Combining multiple xml Document Objects
• Convert xml Document Objects into a query object

Extensible Stylesheet Language (XSL)

• xsl, xslt, and xslfo
• xsl basics: linking to an xsl stylesheet
• Examining an xsl stylesheet
• Server-side xsl transformation with ColdFusion
• Transforming xml data with xsl
• Transforming xml data into xml data

XML Path Language (XPath)

• XPath: the xsl node matching syntax
• Using XPath with ColdFusion
• Using XPath to select specific xml elements

Using Regular Expressions

• Regular expressions for advanced form validation
• Special symbols for matching specific characters
• Specifying the number of occurrences
• Placement of the pattern
• POSIX syntax
• Perl syntax
• Testing regular expressions