|
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. This tutorial
takes you through the development of an actual web page. He reviews FORM:SELECT
and covers other Coldfusion tags also in this tutorials are topics like
creating film pages, scoped variables, cork board, and more. Start learning
now by clicking one of the topics below.
ColdFusion MX provides everything you need to quickly create a variety
of applications, from advanced websites to dynamic publishing systems.
This training course is designed for fast learning and covers all the
fundamental points of the application, all cds work on a mac or pc and
no application is needed.
The links below are
free Cold Fusion tutorials. The entire contents may be purchased either
on CD or watched via the Online University
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.
|
