|
|
|
Intro to Cold Fusion MX for New Programmers
Version MX
Prerequisites
Advanced HTML or equivalent knowledge.
|
| Duration 2 day(s) |
Introduction to ColdFusion
- Overview
- Static Client/Server Model on the Web
- Dynamic Client/Server Model on the Web Using ColdFusion
Web-to-Database Integration Using ColdFusion
- JDBC Data Sources
- JDBC Drivers and SQL
- ODBC Data Source Names (DSNs)
- The Cold Fusion Web to Database Integration Model
- Database and Files Used in Class
Writing ColdFusion Code
- ColdFusion Templates
- Using ColdFusion Studio
- Viewing and Editing the Files for Class in ColdFusion Studio
- Executing the Files for Class in a Web Browser
Writing HTML Tags Using ColdFusion Studio
- Exercise 1: Building an HTML Page with ColdFusion Studio
- A Possible Solution to Exercise 1
- Accessing the Date and Time in ColdFusion
- Date Functions in ColdFusion
- Time Functions in ColdFusion
- Date Formats in ColdFusion
- Time Formats in ColdFusion
- Exercise 2: Date and Time Stamping the Home Page
A Possible Solution to Exercise 2
- Working with Variables in ColdFusion
- Setting Variables with <cfset>
- Displaying the Value a Variable Contains with <cfoutput>
Passing Variables Between Pages in ColdFusion
- Passing Variables Via Links (URLs)
- Passing Variables Via Forms
Building Forms with ColdFusion Studio
- Creating Form Elements
- Exercise 3: Constructing a Short Form and Response Page
- A Possible Solution to Exercise 3
Distinguishing Among Variable Types in ColdFusion
Conditionals in ColdFusion
- <cfif> and <cfelse>Conditionals
- ColdFusion Conditional Operators
- Using <cfif> and <cfelse> to Perform Form Validation
- <cfabort> and Form Validation
Adding One or More <cfelseif> Blocks to a Condititonal
- Exercise 4: Validating a Form on the Server with a Simple ConditionalExpression
- A Possible Solution to Exercise 4
- Database Concepts
- The Databases Used in this Class
An Introduction to SQL
- Issuing Database Commands with SQL
- Retrieving Information with SELECT
- Inserting a Row in a Table with INSERT
- Editing Records with UPDATE
Delete Records with DELETE
- SQL Syntax
- Querying a Database in ColdFusion
- The <cfquery> Tag
- The <cfoutput> Tag and its query Attribute
- Example: A Sample Database Query
- Distinguishing Query Variables From Other ColdFusion Variables
- Counting the Number of Records Returned from a Query withqueryname.recordcount
Exercise 5: Querying the Database for All Artists
- A Possible Solution to Exercise 5
- Displaying Multiple Records Returned by a Query in HTML Table Format93
- Creating HTML Tables Manually
- Creating HTML Tables with the <cftable> Tag
- Exercise 6: Displaying All Artist in Table Format
- A Possible Solution to Exercise 6
Dynamically Populating Select Lists
- Example: Dynamically Populating a Select List via <cfoutput>
- Using <cfselect> to Create Auto-Populating Select Lists
- Exercise 7: Dynamically Generating a Select List
- A Possible Solution to Exercise 7
Implementing Basic Data Drill-Downs
- Explanation of Drill-Down Code
- Exercise 8: Drilling Down to Display an Artist's Works of Art
- A Possible Solution to Exercise 8
Inserting Records into the Database
- Inserting a Record into a Database Table with ColdFusion
- Inserting a Work of Art into the Artworks Table
- Using Hidden Fields to Pass Data in a Form Submission
- Exercise 9: Inserting a Work of Art into the Database
- A Possible Solution to Exercise 9
The <cfinsert> Tag
- When not to use <cfinsert>
- Exercise 10 (optional): Implementing <cfinsert>
- Form Validation
- Client-side Form Validation
- Exercise 11: Building a Client-side Validating Account Creation Form
- A Possible Solution to Exercise 11
- Server-side Form Validation
Exercise 12: Building a Server-side Validating Account Creation Form
- A Possible Solution to Exercise 12
- Editing Records in the Database
- Editing Records with UPDATE
- Building a Editing Application to Edit Works of Art
- Using the <input> Tag's value Attribute to Show Database Values
- The UPDATE Page
- Exercise 13: Editing an Artist's Contact Information
A Possible Solution to Exercise 13
- The <cfupdate> Tag
- Exercise 14 (optional): Implementing <cfupdate>
- Using the <cflocation> Tag to Redirect Users
- The <cflocation> Tag
- The isdefined() Function
- Exercise 15: Automatically Redirecting the Browser
- A Possible Solution to Exercise 15
Deleting Records from the Database
- Removing Records from a Database with the SQL DELETE Statement
- Deleting Works of Art from our Database
- Exercise 16: Deleting a Work of Art from the Database
- A Possible Solution to Exercise 16
Generating Email Messages with the <cfmail> Tag
- Exercise 17: Using the <cfmail> Tag to Auto-generate an EmailMessage
- A Possible Solution to Exercise 17
Appendix A: ColdFusionMX Administrator Configuration Information
- Accessing the ColdFusion Administrator
- Using the ODBC Data Sources Option
- Setting the Mail Server Connection
Appendix B: ColdFusionVariable Types
Appendix C: DebuggingAdvice
Appendix D: RecommendedResources
ICFIMX WESTLAKE - 12/10/2002 0:00:00
|
