Getting Started Building ColdFusion MX Applications

• Introduction
• Introducing ColdFusion MX
  • What is ColdFusion MX?
    • The ColdFusion application server
      • How ColdFusion processes pages
    • The ColdFusion Markup Language
      • Building applications with CFML
      • Interacting with data sources
      • Development tools
    • The ColdFusion MX Administrator
  • Using ColdFusion MX with Macromedia Flash MX
• CFML Basics
  • Working with ColdFusion pages
    • Creating a ColdFusion page
      • Saving your ColdFusion page
      • Browsing your code
  • Understanding CFML elements
    • Tags
    • Functions
    • Variables
      • Naming variables
      • Ways to use variables
    • Creating variables with the cfset tag
    • Displaying variable output
  • Working with CFML expressions
    • Building expressions
      • Specifying a consistent character case
      • Specifying pound signs to denote functions or variables
      • Specifying quotation marks around values
      • Specifying operators in expressions
  • Understanding conditional processing
      • Conditional processing tags
  • Processing form data
    • Form processing
  • Commenting your code
• Database Fundamentals
  • Understanding database basics
    • What is a relational database?
    • Understanding relational tables
  • About SQL
    • Using SQL to interact with a database
  • Using SQL with ColdFusion
    • About data sources
    • Writing SQL and CFML statements to interact with a data source
    • CFML tags that interact with a database
• Configuring Your Development Environment
  • Verifying the tutorial file structure
  • Configuring database connection and debugging options
    • Configuring the connection to the sample database file
    • Enabling debugging options
      • Sending debugging information to remote clients
  • Macromedia development environment tools
    • The Dreamweaver MX environment
      • Features for ColdFusion developers
    • Configuring Dreamweaver MX for ColdFusion development
    • Configuring HomeSite+ for ColdFusion development
• Lesson 1: Preparing to Build the Sample Application
  • Application development steps
  • Determining the application functional requirements
  • Determining the data requirements
  • Designing the database for your application
  • Developing the sample application
    • How to proceed
      • Working directories
      • Requirements
• Lesson 2: Writing Your First ColdFusion Application
  • Creating your first ColdFusion application
    • Application development steps
  • Using a web page to list trips
    • Converting to a dynamic web page
      • Understanding basic SQL SELECT statements
    • Using SQL with cfquery to dynamically retrieve information
      • Displaying the query result using cfoutput
    • Creating a dynamic web page
      • Exercise: building a query using SQL, cfquery, and cfoutput
      • Exercise: enhancing the query
  • Developing a search capability
    • Designing the search criteria page
      • Understanding search query operators
    • Building the Search Results page
      • Building the WHERE Clause with the cfif and cfset
      • Constructing the initial Trip Search Results page
    • Completing the Trip Search Results page
      • Exercise: testing the Trip Search Results page
      • Exercise: enabling the departure and price criteria on the Trip Search form
  • Summary
    • In the next lesson
• Lesson 3: Creating a Main Application Page
  • Enhancing the Trip Maintenance application
    • Showing additional trip details
      • Exercise: building a Trip Detail page
    • Avoiding the potential security risk when using dynamic SQL
      • Protecting your application
    • Linking the Search Results page to the Trip Detail page
      • Exercise: linking the Search Results page with the Trip Detail page
    • Enhancing the look of the search results and detail pages
      • Query variables
      • Exercise: formatting the display
    • Creating the main application page from the Trip Detail page
    • Adding navigation buttons to browse database
      • Exercise: adding navigation buttons to the Trip Detail page
    • Adding database maintenance buttons
      • Exercise: add Maintenance Buttons to Trip Detail Page
  • Summary
    • In the next lesson
• Lesson 4: Validating Data to Enforce Business Rules
  • Enhancing the Trip Maintenance application
  • Using an HTML form to collect data
      • Exercise: view the source and test the Trip Edit page
  • Developing code to validate data and enforce business rules
      • Ways to validate data
    • Validating data using a server-side action page
      • Using a cfif tag to enforce business rules
      • Evaluating whether business rules fail
      • Exercise: create an action page with server-side validation
      • Drawbacks of validating data on the server-side
    • Validating data on the client using ColdFusion form tags
      • Examples of using the improved ColdFusion form tags
      • Exercise: modify Trip Edit page to exploit ColdFusion form tags
    • Using cfselect tag to present valid event types
      • The cfselect tag
      • Exercise: use eventtypes table to load event types
    • Using other client-side script to reduce edits on the server
      • Exercise: add JavaScript-based validation code
    • Validating the existence of the trip photo file
      • Exercise: use FileExists function to verify the existence of photo filename
  • Summary
    • In the next lesson
• Lesson 5: Implementing the Browsing and Maintenance Database Functions
  • Enhancing the Trip Maintenance application
    • Application development steps
    • Using dynamic SQL to browse (navigate) the Trips table
      • Limiting the number of result rows
      • The navigation action page
      • Exercise: implement trip record browsing (navigation)
    • Building the maintenance action page
      • Maintenance action page code
    • Linking the Trip Detail page to the Trip Search page
      • Deleting the current trip record shown on the Trip Detail page
      • Exercise: handle search and delete in maintenance action page
  • Summary
    • In the next lesson
• Lesson 6: Adding and Updating SQL Data
  • Completing the Trip Maintenance application
    • Writing code to save new trips to the database
      • Adding data using SQL INSERT with cfquery approach
      • Exercise: insert trip data using SQL INSERT and cfquery
      • Adding data using the simpler, cfinsert approach
      • Exercise: insert trip data using cfinsert
    • Updating a SQL row using cfupdate
      • Exercise: update trip data using cfupdate
    • Linking the Trip Edit page to the main page
      • Exercise: linking the Add and Edit buttons
    • SQL Update
    • Updating multiple records
      • Exercise: using SQL UPDATE with cfquery
    • Summary

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.