Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.
Expert author Mike Muller describes all the basic to advanced aspects at a very easy pace with the aim of transforming you into a confident user in the shortest time possible! Simply click any linked lesson below for FREE ColdFusion video training movies.
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters 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
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649