Introduction to Macromedia ColdFusion MX Training

ColdFusion MX is the wildly popular server-side language that allows non-programmers to quickly produce data-driven websites. Since the content is stored in a database, the pages are created dynamically. In addition to learning basic ColdFusion techniques, you will learn basic database concepts using Microsoft Access, including how to create Data Source Names (DSN), SQL statements and relational database basics.

We will use real-life examples to show you how to query the database using the <cfquery> tag and display your resulting records using <cfoutput>, <cftable>, <cfselect> and more. Additionally, we will create an administration section that will allow you and your staff to add, edit or delete records in the database.

No previous database or programming experience is required. Knowledge of HTML is all you will need! In class we will write our code from scratch using Dreamweaver MX, ColdFusio Studio or HomeSite +, and we will explore additional code writing options including ColdFusion Studio, HomeSite+, BBedit and Notepad. (If you are interested in using Dreamweaver's WYSIWYG functions to build dynamic pages, see the class entitled "Using Dreamweaver MX to Build Data-Driven Websites.")

Course Outline

• Introduction to ColdFusion
• Writing ColdFusion Templates
• Software Interface
• Dreamweaver MX / ColdFusion Studio / HomeSite +
• EXERCISE: Build a basic HTML page and test it on the server
• Variables and Built-in Functions
• cfset and cfoutput
• Variable Scope and Prefixes
• Date / Time Functions
• EXERCISE: Build Dynamic Page Footer that includes Date and Time
• Passing Variables Between Pages
• "Two-page method"
• HTML Form Review
• Pass Variables with Links
• Building Forms with Dreamweaver MX
• Building Forms with ColdFusion Studio
• EXERCISE: Passing Variables
• Conditional Statements
• cfif, cfelseif and cfelse
• EXERCISE: Basic Form Validation with Conditional Statements
• Database Basics
• Introduction to SQL
• Select Statement
• Update Statement
• Delete Statement
• Use cfquery to query the database
• Quick output with cfdump
• EXERCISE: Query the Database with cfquery
• Display Resulting Records
• Use cfoutput to customize data display
• EXERCISE: Display query results
• Build Dynamic Tables
• Use cfoutput to build table rows
• Shortcut: cftable
• EXERCISE: Display results in a dynamically built table
• Build Dynamic Select Lists
• Use cfoutput to build option tags
• Shortcut: cfselect
• EXERCISE: Display results in a dynamically built select list
• Data drill downs
• Receive a variable and query on it
• Dynamically build the WHERE clause in SQL Statement
• EXERCISE: Pass Primary Key to a Query
• Insert Into the Database
• Create Form
• SQL Insert Statement
• Shortcut: cfinsert
• EXERCISE: Insert New Record
• Form Validation
• Automatic Client-side Form Validation
• EXERCISE: Use the automatic Client-side Form Validation
• Automatic Server-side Form Validation
• EXERCISE: Use the automatic Server-side Form Validation
• Update Database Records
• Create Form
• SQL Update Statement
• Shortcut: cfupdate
• EXERCISE: Update Record
• cflocation
• Redirect the user with cflocation
• EXERCISE: Redirecting users
• Sending Automatic Email
• cfmail
• EXERCISE: Use ColdFusion to send an email
• Delete Records
• Create Form
• SQL Delete Statement
• EXERCISE: Delete Record

See also:

Adobe ColdFusion Training Courses

• Core ColdFusion 9 Training (3 days)
• Advanced ColdFusion 9 Training: Components, Error Handling and Complex Objects (2 days)
• Advanced ColdFusion 9 Training: XML, External Data and File System (2 days)
• ColdFusion 9 and Reporting (2 days)
• ColdFusion 9 and Ajax (2 days)
• What's New in ColdFusion 9 (2 days)

• Core ColdFusion 8 (3 days)
• Advanced ColdFusion 8: Components, Error Handling and Complex Objects (2 days)
• Advanced ColdFusion 8: XML, External Data and File System (2 days)
• ColdFusion 8 and Reporting (2 days)
• ColdFusion 8 and Ajax (2 days)
• What's New in ColdFusion 8 (2 days)

• Introduction to ColdFusion MX 7 (3 days)
• Advanced ColdFusion MX 7 (4 days)

• Introduction to ColdFusion MX (2 days)
• Advanced ColdFusion MX (3 days)
• ColdFusion MX, Web Services and XML (2 days)
• FuseBox 4.1 Training (2 day)
• Building Data-driven Websites with Dreamweaver 8(using ColdFusion, PHP, ASP.NET or ASP) (2 days)
• Flash Remoting MX: Integrating Flash and ColdFusion (2 days)