Beginning ColdFusion 10

Beginning ColdFusion 10

This ColdFusion 10 course teaches attendees how to build their first data-driven web applications using ColdFusion.

COLDFUSION TRAINING OBJECTIVES

• Retrieve data from a database and display it on the page
• Insert, Update, and Delete records in a database
• Submit data using HTML forms
• Create Dynamic Form Fields including Dynamic Select Lists
• Build a Database Search Interfaces
• Use Session Variables to provide Password Protection
• Create and call ColdFusion

COLDFUSION TRAINING PREREQUISITES

All Beginning ColdFusion students must be fluent in HTML.  Prior experience with SQL and HTML is recommended but not required.

COLDFUSION TRAINING MATERIALS

All students receive a copy of Adobe Press’ ColdFusion 10 Web Application Construction Kit, and related courseware.

SOFTWARE NEEDED FOR EACH PC:

• Any modern version of Windows, Mac OS X, or Linux, with at least 3 GB of RAM
• ColdFusion 10 or later – ColdFusion should be set up to run as a stand-alone server for purposes of the class.
• Adobe Dreamweaver CS6 or later, ColdFusion Builder 2 or later, or other ColdFusion IDE of your choice
• Modern web browser
• For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

COLDFUSION TRAINING OUTLINE

• Introduction to ColdFusion
  • Static pages vs. Dynamic pages
  • Server-side Web Technologies
  • Database Alphabet Soup: ODBC/JDBC, DSNs and SQL
  • Course Objectives and Prerequisites
  • Introduction to Course Project
• ColdFusion Basics
  • Using CFML
    • Code Editors
    • Dreamweaver Interface
    • Tag Updaters / Extensions
    • Tag Editing Dialog Boxes
  • Embedded Tag Help
  • Using ColdFusion Comments
  • Creating Variables
    • <cfset> and <cfoutput>
  • Variable Scope/Prefixes
  • Built-in ColdFusion Functions
  • Built-in Functions
  • Date / Time Functions
  • Using <cfinclude> to reuse code
    • Create Header and Footer with <cfinclude>
    • Build Dynamic Page Footer using Variables and Date Functions
• Dynamic Data: Querying the Database
  • Database Basics
    • Introduction to SQL
    • Select Statement
    • Update Statement
    • Insert Statement
    • Delete Statement
    • Data Source Name (DSN)  Remote Development Server (RDS)
    • The DSN Used in This Class: movieList
  • Course Project Database
  • Querying the database with <cfquery>
    • <cfdump> for Quick Output
    • Query the database
  • Customizing Display with <cfoutput>
    • Using <cfoutput>
    • Building Dynamic Tables
    • Shortcut: <cftable>
    • Shortcut: Dynamic Table Tool (in Dreamweaver)
    • Display Resulting Records manually with <cfoutput>
• Creating a Drill-down Interface
  • Passing Variables between Pages
    • “Two-page method”
    • Pass Variables via Links
    • List of Actors with links
  • Receive Variables through the URL
    • Using a WHERE clause in a SQL Statement
    • Protecting Against SQL Injection Attacks with <cfqueryparam>
    • Drill-down for More Detail
• Conditional Statements and Forms
  • Conditional Statements
    • <cfif>, <cfelseif> and <cfelse>
    • Comparison Operators
    • Operator
    • Description
    • Conditional Statements
    • Using the isDefined() function
    • Conditional Statements – Data Validation
  • HTML Form Review
    • Pass Variable through a Form
    • Process Form Submission
  • Self-Submitting Forms
    • Using the <cfparam> tag to set a default value
    • Quick Examination of a ColdFusion Framework (Methodology): Fusebox
    • Self-submitting Form
  • Dynamically Populating Select Lists
    • HTML Review: <select> tags
    • Dynamic Select List
    • Introducing the <cfform> Tag
    • Shortcut: <cfselect>
    • Create a Dynamic Select List
• Quick Introduction to RSS and Ajax with <cfform>
  • Reading an RSS Feed
  • Consuming an RSS Feed
  • Creating an RSS Feed
  • Introducing the <cfform> Tag
  • Building a Mask with <cfform>
  • Automatically Build a Dynamic Select List with <cfselect>
  • Creating an Auto Suggest Text Field with <cfform>
• Creating a Search Interface
  • Using the LIKE clause
  • Using % and _ in a LIKE Statement
  • Building Dynamic SQL Statements
  • Create a Search Interface
• Insert Records into the Database
  • Inserting Records
    • SQL Insert Statement
    • Insert Record Step 1 – the Form
    • Insert Record Step 2 – the Insert
    • Shortcut: <cfinsert>
    • Redirect Users with <cflocation>
    • Insert a New Actor in the Database
  • Automated Form Validation
    • Client-side vs. Server-side validation: When does the validation code run?
    • Automatic Client-side (or Server-side) Form Validation
• Edit (Update) Database Records
  • Updating records
    • SQL UPDATE Statement Review
    • Update Record Page 1 – select the record to edit
    • Passing the Primary Key
    • Page 2 – View Current Data in a Form
    • Page 3 – Perform the Update to the Database
    • Shortcut: <cfupdate>
    • Edit a Record
  • Deleting Records
    • Note on Deleting records
    • Review of the SQL Delete Statement
    • “Deleting” without deleting
    • No <cfdelete>!
• Reusing Code
  • Reusing code with <cfinclude> and <cflocation>
  • Custom Tags
    • custom tags
    • Where to store Custom Tags
    • Custom Tag with Parameters
    • CALLER and ATTRIBUTE scopes
    • Using <cfmodule>
    • A Note about CFX tags
    • Calling a Custom Tag to Display a List of Years
  • User Defined Functions (UDFs) and ColdFusion Components (CFCs)
    • Creating UDFs with the <cffunction> tag
    • Using ColdFusion Components (CFCs)
    • Creating Components
    • Calling or Invoking Components
    • Passing Arguments to Components
    • The Component Code
    • The main CFML page
    • View a Component directly in the browser
• Using Session Variables for Password Protection
  • Using Application.cfc to Enable Session Management
  • Creating Password Protected Pages
  • Password-protect.cfm (the included page)
  • Application.cfm
  • Locking Session and Application variables with <cflock>
  • Password Protecting Pages (optional)
• Sending email with <cfmail> (optional)
  • <cfmail> Tag Syntax
  • Sending an email
  • Sending Automated Emails
  • New in ColdFusion 10: sending emails via Microsoft Exchange
• Conclusion