Audience:
Web
developers, Webmasters, and any persons responsible for the
modification and enhancement of Internet, Intranet, or Extranet
sites.
Prerequisites:
Basic familiarity with Web terminology
Knowledge
of the HTML tag set and syntax
Knowledge
of SQL (Select, Insert, Update, and Delete)
Completion
of an Introduction to ColdFusion course
A minimum
of two months extensive experience developing with ColdFusion
is suggested
Lesson Format and Course Objectives:
Our courseware is designed around class lectures, demonstrations,
walkthroughs, and a class lab, which together will teach you
to:
Use Lists, Arrays, and Structures
Use session
variables and secure ColdFusion sites
Use ColdFusion structured error handling
Create
graphs with <CFGRAPH>
Integrate
Verity search technology with ColdFusion
Skillfully
use <CFHTTP> and <CFFTP>
Understand
and use custom tags
Use XML
and ColdFusion, the WDDX specification
Use ColdFusion scripting, <CFSCRIPT>
Use advanced
SQL with ColdFusion
Extend
ColdFusion with COM
At
the end of three days, you will have the increased ColdFusion
skills to continue your development of ColdFusion applications
with much greater expertise.
Unit
1: Lists, Arrays, and Structures
Using advanced data types
Working
with ColdFusion lists
Working
with ColdFusion arrays
Working
with ColdFusion structures
Understanding
and using list, array, and structure functions
Unit
2: Working with Sessions and ColdFusion Security
The Web's statelessness
Using
cookies
Using
client variables
Using
session variables
Options
for application security
Using
ColdFusion to control access
Using
session variables for authentication
Creating
a login page
Verifying
the login name and password
Unit
3: Structured Error Handling
Catching errors as they occur
Using
<CFTRY> and <CFCATCH>
Basic
exception handling
Templates
that work around errors
Templates
that recover from errors
Nesting
<CFTRY> blocks
Using
<CFTHROW>
Unit
4: Graphing
Using <CFGRAPH>
Using
<CFGRAPHDATA>
File
formats
Building
a graphing application
Unit
5: Integrating Verity Search with ColdFusion
Becoming familiar with verity
Searching
for different types of files
Creating
a search tool for your documents
Indexing
SQL data
Using
<CFCOLLECTION> to administrate Verity
Expanding
Verity's power
Understanding
Verity's search
Unit
6: Creating Intelligent Agents
Using <CFHTTP>
Using
<CFHTTPPARAM>
Building
a query from a text file
Creating
intelligent agents with <CFFTP>
Using
<CFFTP>
Connecting
with <CFFTP>
Performing
file and directory operations with <CFFTP>
Unit
7: Custom Tags
The basic idea
How to
use custom tags
The <CFMODULE>
tag
Using
custom tags to display information
Using
<CFPARAM> to set default values
Custom
tags that process data
Custom
tags that encapsulate business rules
Custom
tags for general-purpose use
Unit
8: ColdFusion and XML, the WDDX Specification
What is WDDX?
The <CFWDDX>
tag
The CFML2WDDX
action attribute
The WDDX2CFML
action attribute
WDDX
and JavaScript
WDDX
interface for COM
Integrating
with Active Server Pages
Integrating
with ColdFusion and JavaScript at once
Integrating
with Visual Basic
Integrating
with MS Office Applications
Fetching
WDDX packets with JavaScript
Unit
9: ColdFusion Scripting
Understanding <CFSCRIPT>
Why use
<CFSCRIPT>?
Tag overview
Using
<CFSCRIPT>
Unsupported
tags and functions
Common
errors and resolutions
Creating
your own functions
Unit
10: Advanced SQL Topics
Using Distinct
Using
aggregate functions
Selecting
related data with joins
Subqueries
Using
Union to combine two select queries
Using
Insert and Select to move data between tables
Working
with nulls
Working
with dates
Understanding
views
Manipulating
data with scalar functions
Additional
query topics
Using
<CFTRANSACTION>
Unit
11: Extending ColdFusion with COM
Understanding COM
Introduction
to <CFOBJECT>
Using
COM
Integrating
with MS Word
Integrating
with MS Excel
Integrating
with Outlook and Exchange
Scope
of objects
Troubleshooting
COM
