ColdFusion 9 Essentials

Introduction
Welcome
Using the exercise files
Overview

1. Getting Started (35:16)
Understanding application servers
Installing ColdFusion 9 on Windows
Installing ColdFusion 9 on Mac OS X
Completing the Configuration wizard
Starting and stopping ColdFusion on Windows
Starting and stopping ColdFusion on Mac OS X
Installing ColdFusion Builder on Windows
Installing ColdFusion Builder on Mac OS X
Setting folder permissions on Mac OS X

2. Using ColdFusion Builder (45:34)
Using Eclipse perspectives and views
Defining a ColdFusion server
Creating a ColdFusion project
Creating and browsing a ColdFusion page
Defining a default page template
Setting and outputting variables
Using the Snippets view
Using an external browser
Using online help

3. Understanding Data Types and Debugging Tools (35:48)
Adding numbers and concatenating strings
Using Debug Output
Inspecting variables with <cfdump>
Using arrays
Using structures
Configuring the line debugger
Using the line debugger

4. Working with Databases (53:45)
Scripting an Apache Derby database
Defining a data source in ColdFusion Administrator
Exploring data sources in RDS Dataview
Using SQL and the <cfquery> tag
Outputting data from a query object
Outputting a dynamic HTML table from a query
Generating alternating row colors
Creating an application directory and home page
Displaying data on the home page
Redirecting requests with <cflocation>

5. Using Includes and Custom Tags (32:17)
Including pages with <cfinclude>
Creating reusable header and footer files with <cfinclude>
Creating and calling custom tags
Passing data into custom tags
Setting default values for custom tag attributes
Calling custom tags with <cfmodule>
Using a custom tag as a website header
Creating an application template file

6. Using ColdFusion Components (CFCs) (52:06)
Creating a ColdFusion Component (CFC)
Declaring CFC functions
Calling CFC methods with <cfinvoke>
Using CFC properties
Passing data into functions
Creating and calling CFCs with script syntax
Generating data access CFCs in ColdFusion Builder
Calling generated data access methods
Creating a dynamic HTML table from an array
Creating an Application.cfc file
Using an application data source variable

7. Using ColdFusion Object Relational Mapping (ORM) (32:56)
Generating an ORM map component
Enabling an application to use ORM
Retrieving data with ORM
Generating mappings for multiple tables
Filtering data with ORM
Displaying result data with a custom tag

8. Creating Drill-Down Navigation (27:58)
Passing URL variables in hyperlinks
Passing multiple URL variables
Encoding URLs with URLEncodedFormat()
Checking for available variables with isDefined()
Creating a data-driven hyperlink
Displaying selected data in a detail page

9. Building Data Entry Forms (40:36)
Using HTML data entry forms
Processing form variables
Creating self-posting forms with <cfform>
Creating a search interface
Processing complex queries with HQL
Creating a dynamic pulldown list with <cfselect>
Displaying form results

10. Maintaining Data with Forms and ORM (43:46)
Building a data entry form for managing data
Preparing an ORM mapping for inserting data
Inserting data with ORM
Retrieving data for an update form
Populating form controls with existing data
Updating data with ORM
Confirming actions with an Ajax message box
Using JavaScript callback functions
Deleting data with ORM

11. Validating Data Entry Forms (09:37)
Defining client-side form validation rules
Validating on the server with custom CFML

12. Securing ColdFusion Applications (18:09)
Using the Application.cfc onRequest() method
Creating and using a login form
Authenticating users with <cflogin>
Logging out users

13. Deploying Applications with ColdFusion Builder (07:11)
Configuring an FTP site
Setting a ColdFusion project's synchronization connection
Uploading files to the production server
00:46 Conclusion
Goodbye