ColdFusion MX Introduction for New Programmers

ColdFusion is a Web server add-on for Windows, Linux, and Solaris that makes integrating real-time database information with your Web site as easy as adding a few new tags to your pages.

After completing this two-day course, students will be able to:

• Understand ColdFusion Architecture and Applications
• Build Database-Driven Pages With ColdFusion Markup Language
• Harness the Power of ColdFusion Server
• Debug and Foolproof Your ColdFusion Applications

Target audience

All students should have an excellent working knowledge of HTML gained through practical experience or by attendance on an advanced-level course

Course content

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

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

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

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 Conditional Expression

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

Displaying Multiple Records Returned by a Query in HTML Table Format Creating HTML Tables Manually • Creating HTML Tables with the <cftable> Tag • Exercise 6: Displaying All Artist in Table Format

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

Implementing Basic Data Drill-Downs Explanation of Drill-Down Code • Exercise 8: Drilling Down to Display an Artist's Works of Art

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 • 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 • Server-side Form Validation • Exercise 12: Building a Server-side Validating Account Creation Form

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 • 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

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

Generating Email Messages with the <cfmail> Tag Exercise 17: Using the <cfmail> Tag to Auto-generate an Email Message

Appendix A: ColdFusionMX Administrator Configuration Information Accessing the ColdFusion Administrator • Using the ODBC Data Sources Option • Setting the Mail Server Connection

Appendix B: ColdFusion Variable Types

Appendix C: Debugging Advice

Appendix D: Recommended Resources

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today