Macromedia 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; browser info (user_agent etc)

Suggestions for further development

The Last Word

Closing; Resources; and Thank You.