ColdFusion MX Introduction for 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 one-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 a strong knowledge of HTML plus experience with using a modern programming or scripting language such as Perl,C++ or Visual Basic. Students must also be familiar with SQL

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 • <c fabort> and Form Validation • Adding One or More <c felseif> Blocks to a Conditional • Exercise 4: Validating a Form on the Server with a Simple Conditional Expression

Database Concepts The Databases Used in this Class

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