• Platform:    Windows, Macintosh
• Media: CD-ROM
• Item Quantity: 1

Cold Fusion
Author Mike Muller
Movies 86
Duration 8 Hours

Macromedia's Cold Fusion is a rapid application development system.
Through the use of tag-based scripting language, it enables you to
build and deploy powerful application. If you have any type of
programming experience, learning Cold Fusion is a breeze with the
help of Mike Muller. He guides you in this Virtual Training Company
tutorial by taking you through the development of an actual web page.
He reviews FORM:SELECT and covers creating film pages, scoped
variables, cork board, and more.

Tutorials covered on this CD:
Introduction
What is Cold Fusion?
What's Covered? What Should You Know?
Additional Resources and Support
What You Need to Develop in CF
CF Studio: Connecting to the Server Via FTP
Absolute FTP: Connecting to the Server

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

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

The Business Directory
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

The Films Page
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
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

The Cork Board
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

The Cork Board Continued
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.