Advanced Web Development with ColdFusion is a 3-day course that provides experienced ColdFusion professionals with the advanced skills necessary to create industrial strength ColdFusion applications.

Topics
The Advanced Web Development with ColdFusion course covers advanced development topics including Remote Development Services; Debugging; Advanced Data Types; CFML Scripting; Exception and Error Handling; Advanced Custom Tags; Advanced Query Techniques; Database Optimation; Query Caching; Stored Procedures; Transaction Processing; Creating CFX Tags in Java, C++ and Delphi; Interfacing with Java, COM and CORBA Objects; Using CFEXECUTE; Graphing and Drill-down Graphs; File Management with CFFILE and CFDIRECTORY; Interacting with FTP, HTTP, SMTP, POP Servers; Transferring Data with XML and WDDX.

Objectives
Upon completion of this course, you should be able to:
Examine a completed ColdFusion Application that implements all lesson objectives.
Understand URL parameters, and create a data drill-down interface.
Gather information using an HTML form, submit the gathered information, and work with action page variables.
Implement client-side validation via the cfform tag, and dynamically populate form fields.
Utilize CFML conditional tags, conditional operators, and the cfloop tag.
Construct dynamic SQL statements and implement server-side validation.
Discuss how the concepts covered in this course can be applied to a Web application.
Create the components that allow you to insert data into a database.
Create the components that allow you to update and delete data in a database.
Create and process conditional forms.
Explain the importance of state management and describe client-side state management techniques.
Implement server-side management techniques and restrict access to your application.

Prerequisites
To gain the most from this class, you should already have:
Attended the Introduction to ColdFusion Core Concepts class.
Three months experience developing and deploying ColdFusion Web applications.
Practical experience with the SQL command set.

Course Outline
Chapter 1 - Remote Development Services Chapter 1 - Remote Development Services
The Localhost RDS
Creating a New RDS Server
Configuring an Existing RDS Server
RDS Security
Using an RDS Server
Development Mappings
Configuring Development Mappings
Mappings for a Localhost Resource
Mappings for a Network Resource
Mappings for an RDS Resource
Exercises
Summary
Chapter 2 - Debugging Techniques
Displaying Debug Information
Displaying Variable Scopes
Debugger Options in the ColdFusion Administrator
Debugging IPs
Debug Mode
Using the Integrated Debugger
Debugging Options
Starting the Debugger
RDS Mappings and the Debugger
The Debug Window
Breakpoints
The Breakpoints List
Conditional Breakpoints
Wildcard Breakpoints
Stepping Through Code
Watches
Expressions
Exercises
Summary
Chapter 3 - Advanced Data Types
Lists
Delimiters
List Functions
Processing Lists
Processing Queries with Lists
Arrays
Creating an Array
Two-Dimensional Arrays
Three-Dimensional Arrays
Arrays of Arrays
Array Functions
Structures
Predefined ColdFusion Structures
Array Syntax for Structures
Complex Structures
Structure Functions
Pointers to Structures
Combining Arrays and Structures
Query Variables
Queries as Arrays
Creating Query Variables
Adding Columns to a Query
Exercises
Summary
Chapter 4 - CFML Scripting
Using the CFSCRIPT Tag
Writing to Output
Operators
Variables
Interaction Between CFML and CFScript
Accessing Scoped Variables
CFScript Statements
Comments
Commenting Out Scripts
Branching
Statement Blocks
Switching
Looping
Array Processing with For Loops
Looping Through Structures
The While Statement
The Do-While Statement
Break and Continue
User Defined Functions
Creating Functions
The Return Statement
Calling Functions
Placement of Functions
Determining Function Existence
Defining Local Variables
Passing Parameters
Optional Parameters
Passing by Value
Passing by Reference
Passing Arrays by Reference
Passing Functions as Parameters
Function Libraries
Exercises
Summary
Chapter 5 - Exception and Error Handling
Handling Errors with CFERROR
Using the CFERROR Tag
Error Variables
CFERROR Attributes
Error Page Types
Template
Mail To
Exception Types
Site-wide Error Handling
Suppressing Template Paths
Projecting Code with CFTRY
Local Handling of Exceptions
Using cfcatch Variables
cfcatch Properties
Handling Multiple Exception Types
Raising Exceptions with CFTHROW
CFTHROW Attributes
Custom Exception Patterns
CFRETHROW
Exercises
Summary
Chapter 6 - Custom Tags
Template-based Tags
Tag Attributes
Execution Modes
Nested Tags
Creating Nested Tags
Tag Context
Passing Data Between Nested Tags
Request Scope
GetBaseTagData()
Caller Scope
Parent and Child Tags
CFASSOCIATE
Exiting Tags with CFEXIT
Exiting a Tag
Exiting a Tag Template
Looping
Using the CFEXIT Tag
CFMODULE
TEMPLATE
NAME
Passing Attributes
Exercises
Summary
Chapter 7 - Advanced Query Techniques
Specialized Data Handling
CreateODBCDate()
Handling NULL Values
Converting Missing Form Values to NULLs
Drill-Down Queries
Dynamic SQL Statements
Dynamic Search Conditions
Dynamic Column Lists
Dynamic Table Names
Dynamic Ordering
Parameterized Queries
Bind Parameters
Data Type Validation
Setting a Maximum Length
Security in SQL Statements
Query of Queries
Aggregates in a Query of a Query
Joining Queries
Limitations of Queries of Queries
Exercises
Summary
Chapter 8 - Advanced Database Management
Query Caching
Caching Shared Queries
The CFCACHE Tag
CFCACHE Attributes
Map Files
ColdFusion Scheduler
Automation Settings
Automation Tasks
Stored Procedures
The CFSTOREDPROC Tag
CFSTOREDPROC Attributes
Passing Parameters to a Procedure
CFPROCPARAM Attributes
Transaction Processing
How CFTRANSACTION Works
Trapping Errors in Transactions
Committing Changes
Rolling Back Changes
Limits of the CFTRANSACTION Tag
Exercises
Summary
Chapter 9 - Extending ColdFusion
CFX Tags
Requirements for Creating a CFX Tag
Creating a CFX Tag in Java
Compiling a Java CFX
Registering the Java CFX
Testing the Java CFX
Configuring Java Settings
Java Class Loading
Automatic Class Reloading
Processing Requests
The Request Object
The Response Object
The Query Object
Creating a CFX Tag in C++
CFC C++ Classes
Creating a CFX Tag in Delphi
CFEXECUTE
CFXEXECUTE Attributes
Exceptions in CFEXECUTE
Using COM, CORBA and Java Objects
The CFOBJECT Tag
Accessing Object Properties
Calling Object Methods
CFOBJECT Attributes
Working with COM Objects
Requirements for COM
Registering COM Servers
OLEView
Instantiating COM Objects
Working with CORBA Objects
Instantiating CORBA Objects
Exceptions in CORBA Objects
Working with Java Objects
Instantiating Java Objects
Creating a Java Class
Using a Java Object
Explicit Construction
Data Type Conversions
The JavaCast() Function
Exception Handling in Java Objects
Retrieving Java Exception Objects
Exercises
Summary
Chapter 10 - Graphs
Using CFGRAPH
Graphing SQL Query Results
CFGRAPH Query Attributes
Adding Data Points to a Query Graph
Graph Formatting
Bar Chart Formatting
Pie Chart Attributes
Line and Area Chart Attributes
Drill-down Graphs
Creating Drill-Down Graphs
Exercises
Summary
Chapter 11 - File Management
File Management Using CFFILE
File Management in ColdFusion
The ACTION Attribute
Copying Files
Moving Files
Renaming a File
Changing Attributes
Deleting a File
File Management Functions
Reading and Writing Files
Reading a Text File
Writing to a Text File
Appending to a Text File
Reading Binary Data
Uploading Files
Handling Name Conflicts
Accepting Specific File Types
Accessing File Upload Information
CFDIRECTORY
Returning File Information
Filtering a Directory List
Sorting a Directory List
Exercises
Summary
Chapter 12 - Remote Server Operations
File Transfer Protocol (FTP)
Creating a Local FTP Server for Testing
The CFFTP Tag
Opening an FTP Connection
Listing Directory Information
Closing an FTP Connection
Single Action FTP Operations
Caching FTP Connections
FTP File and Directory Operations
Directory Listings
File Transfers
HTTP Operations
Saving a Retrieved URL to a File
Retrieving a Binary File
HTTP Post
Mail Server Operations
Configuring an SMTP Server in ColdFusion
Sending Mail with CFMAIL
Sending Mail to Multiple Users
Mail Attachments
Receiving Mail with CFPOP
Additional CFPOP Parameters
Transferring Data with XML and WDDX
WDDX
The CFWDDX Tag
CFWDDX Attributes
CFWDDX Actions
Transferring WDDX Data
Time Zone Processing
WDDX and JavaScript
Exercises
Summary
Appendices
Appendix A - Advanced Exception Types
Appendix B - Northwind Stored Procedures