ColdFusion

Introduction

What is Cold Fusion?
Whats 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

Adhering to Standards

Building a Site with Standards
Design Concepts CFINCLUDE Templates
Creating the Access Database
Importing Flat File into Access
What Well 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; owser info (user_agent etc)
Suggestions for further development

The Last Word

Closing; Resources; and Thank You.