Cold Fusion Tutorial Video

What is Cold Fusion?
 What's Covered? What ShouldYou Know? Demo
 Additional Resources and Support Demo
 What You Need to Develop in CF Demo
 CF Studio: Connecting to the Server Via FTP Demo
 Absolute FTP: Connecting to the Server Demo

Building a Site with Standards
 Design Concepts CFINCLUDE Templates Demo
 Creating the Access Database Demo
 Importing Flat File into Access Demo
 What We'll Shoot for Demo

Quick Review of FORM:SELECT
 SQL:SELECT; CFQUERY; CFOUTPUT Demo
 FORM:SELECT MULTIPLE; Dynamically! Demo

If you purchase the CD all the contents listed below are also included.

Working on the Business Directory (in progress)
CFIF nbsp for phone number
CFIF; TRIM(); SQL:WHERE
SQL:LIKE/OR; search on description
CEILING() every other line gray
CFIF no criteria; no results
CFIF Show all search criteria
ARRAYNEW; "Found 5 instances"
A look at the database. Preferred
Set up dynamic link to business_info.cfm
CFPARAM; CFLOCATION: No ID? No page!
Create business_info.cfm
Create business_add.cfm and dropdowns
SQL Check if #company# exists
SQL:INSERT into business table
CFIF; CFSET no blank fields
Cleanup; suggestions. Fix Accepted

Creating the Films Page
CFHTTP Get search results
REPLACE() Make all URLs absolute
LEN; FIND; RIGHT; Start cleaning up results
LEN; FIND; RIGHT; Continued
LEFT; Finish cleaning up results; and suggestions

admin Pages; scoped variables; CFAPPLICATION
Create the admin login. RIGHT; LEFT; LEN
Logging in; setting CLIENT variables; the menu
Setting up Link; Link_type tables in Access
Describe the Links Admin application
Coding the links.cfm page; SQL
Listing all links and linking back to form
Prefilling in form with link data
Building a dynamic SELECTED Drop-down list
Drop-down list using CFLOOP; ARRAYNEW
Modify; Delete specific record. CFINPUT
Links_action; NOW; DATEFORMAT; LIKE
Links_action; UPDATE; DELETE; INSERT
Cleaning up links.cfm and working on link_types
Show links by category; CFOUTPUT inside CFLOOP
Cleaning up output; query.RECORDCOUNT
Links_add; copied from links and links_action
Cleaning up output of links_add form
CFMAIL the new link to me/you
CFMAIL continued

Discussing Strategy for the Cork Board
Designing the database tables
Stealing code; making SQL
Stealing code; making SQL
Stealing code; making SQL
Digest results on the homepage
Creating the corkboard page
Starting to show results
Renaming corkboard_msg.cfm
Prefilling in the search form
Starting search results
Fixing search results
Cleaning up search results
Adding default digest messages
Add Show full story links
Finishing results
Creating the "Add your own" form
The action page TIMEFORMAT()
Special SQL [ ] commands

Return to Admin to Manage Corkboard
Corkboard.cfm SQL:TOP/ORDER BY
Corkboard.cfm continue CFLOOP:STEP
Corkboard.cfm; sort by table headers
Corkboard_action.cfm

User Join / Login
User Logins on the Website Overview
Logging in: menu; login; login_action
Email_action; verify; verify_action.cfm
Join.cfm
Join_action.cfm and checking info
Edit_me.cfm
Pre-fill in corkboard form w/ user info
Show_user.cfm
Walk through app. Set up FZ account
Tracking.cfm; browser info (user_agent etc)
Suggestions for further development

The Last Word
Closing; Resources; and Thank You