Macromedia ColdFusion Tutorial

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

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

The Films Page
Chapter Overview
CFHTTP Get search results
REPLACE() Making all URLs absolute
LEN; FIND; RIGHT; Start cleaning up results
LEN; FIND; RIGHT; Continued
LEFT; Finish clean up results; and suggestions

Admin Pages
Chapter Overview; scoped variables; CFAPPLICATION
Creating the admin login. RIGHT; LEFT; LEN
Log in; set CLIENT variables
Set up Link; Link_type tables in Access
Links Admin application
Code the links.cfm page; SQL
List all links and link back to form Explained
Prefill in form using link data
Constructing a dynamic SELECTED Drop-down list
Drop-down list with CFLOOP; ARRAYNEW
Modify; Delete specific record. CFINPUT
Links_action; NOW; DATEFORMAT; LIKE
Links_action; UPDATE; DELETE; INSERT
Clean up links.cfm and link_types
Displaying links by category; CFOUTPUT inside CFLOOP
Clean up output; query.RECORDCOUNT
Links_add; copy from links and links_action
Clean up output of links_add form
CFMAIL the new link to me/you
CFMAIL cntd

The Cork Board
Strategy for the Cork Board - Overview
Design the database tables - Step by Step
Stealing code; Creating SQL - Lesson 1
Stealing code; Creating SQL - Lesson 2
Stealing code; Creating SQL - Lesson 3
Digest results on the homepage
Constructing the corkboard page
Now to Show the results
Rename corkboard_msg.cfm
Prefill in the search form
Start and Fix search results - Lesson 1
Start and Fix search results - Lesson 2
Clean up search results
The Addition of default digest messages
Adding Show full story links
Finish results
Create the Add your own form
The action page TIMEFORMAT()
Special SQL [ ] commands

The Cork Board Continued
Admin to Manage Corkboard
Corkboard.cfm:
• SQL:TOP/ORDER BY
• continue CFLOOP:STEP
• sort by table headers
Corkboard_action.cfm

User Join / Login
User Logins on the site Overview
Log in: menu; login; login_action
Email_action; verify; verify_action.cfm
Join.cfm Explained
Join_action.cfm and check info
Edit_me.cfm
Pre-fill in corkboard form with user info
Show_user.cfm
Walk through application Set up FZ account
Tracking.cfm; browser info (user_agent etc)
Further development

The Last Word
Closing; Further Resources; and Macromedia ColdFusion Tutorial Overview