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 8 Training Courses
|
