Macromedia s ColdFusion is a rapid application development platform. Through the use of a tag-based scripting language, it enables you to build and to deploy powerful web-based applications. Even if you do not have any type of programming experience, learning ColdFusion is a breeze with the help of Mike Muller. He guides you through this Virtual Training Company tutorial by taking you through the development of an actual community web site. He reviews connecting to databases with SQL, using includes and scoped variables. He also covers the user log-in process, creating 'cork boards,' searchable directories, 'screen-scraping,' and much more. Start learning now by clicking one of the topics below.
IntroductionWhat is Cold Fusion?Whats Covered? What Should You Know?Additional Resources and SupportWhat You Need to Develop in CFCF Studio: Connecting to the Server Via FTPAbsolute FTP: Connecting to the ServerAdhering to StandardsBuilding a Site with StandardsDesign Concepts CFINCLUDE TemplatesCreating the Access DatabaseImporting Flat File into AccessWhat Well Shoot forReviewQuick Review of FORM:SELECTSQL:SELECT; CFQUERY; CFOUTPUTFORM:SELECT MULTIPLE; Dynamically!The Business DirectoryWorking 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
The Films PageCreating 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 Pagesadmin 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
The Cork BoardDiscussing 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
The Cork Board ContinuedReturn 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 / LoginUser 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; owser info (user_agent etc)
Suggestions for further development
The Last WordClosing; Resources; and Thank You.
Click here to find out more about the Macromedia ColdFusion Training CD 
