Macromedia ColdFusion
Training
Provided by The Virtual Training Company
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.
|
|
||||||||
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.
About The Training Provider: The Virtual Training Company
The Virtual Training Company - The Virtual Training Company started in California's Silicon Valley in 1996.
VTC grew quickly over the next three years and relocated first in 1999 to the beautiful town of Winchester, Virginia; and six years later to Stephens City, Virginia.
The company was founded by British born Mark Vernon who started producing CD-based training for Apple software. The format on the CDs - narrated...
