Enter your Sign on user name and password.

Forgot password?
Sign In | Subscribe
Start learning today, and be successful in your academic & professional career. Start Today!

Table of Contents

I. Introduction
Course Overview

2m 2s

The Course Environment

2m 23s

II. Setting Up the Dynamic Environment
Static vs. Dynamic Requests

5m 40s

Installing ColdFusion

10m 33s

Installing the Course Files

4m 34s

Modifying the ColdFusion Administrator

5m 15s

Installing ColdFusion Builder

7m 16s

Setting Up ColdFusion Builder

7m 36s

III. Working with ColdFusion
Using ColdFusion Templates

7m 16s

Variable Scoping

6m 55s

Setting and Displaying Variables

7m 58s

Creating Include Files

7m 9s

Understanding Page Processing

5m 3s

Building a Template

5m

IV. Creating Data-Driven Pages
Setting Up the Datasource, Part 1

7m 28s

Setting Up the Datasource, Part 2

6m 11s

Getting Data from the Database

6m 40s

Displaying Query Data

8m 12s

Understanding Query Properties

6m 53s

Using the CFDUMP Tag

6m 15s

Debugging

8m 10s

V. Passing Data Between Pages
URL Variables

4m 2s

Passing Data Between Pages

9m 35s

Testing for Variables

8m 42s

Setting Up the Tours Process

8m 32s

Completing the Tours Process, Part 1

8m 9s

Completing the Tours Process, Part 2

8m 55s

VI. Using ColdFusion Forms
Form Basics

5m 9s

Benefits of ColdFusion Forms

2m 17s

Updating a Form

7m 20s

Converting Fields to ColdFusion Fields

3m 35s

VII. Form Data Validation
Form Validation

6m 52s

ColdFusion Validation Options

8m 17s

Adding ColdFusion Validation

6m 12s

Building an Action Page

12m 37s

Redirecting the User

4m 48s

Using the CFMAIL Tag

8m 4s

Bringing It All Together

4m 52s

Loading...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of ColdFusion 9
  • Discussion

  • Study Guides

  • Table of Contents

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

  • Unlimited access to our entire library of courses.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lesson files for programming and software training practice.
  • Track your course viewing progress.
  • Download lecture slides for taking notes.
  • Learn at your own pace... anytime, anywhere!

Setting Up the Datasource, Part 1

  • In order to get data from the database, we use the cfquery tag
  • Inside the cfquery tag you can put anything that evaluates to create valid SQL
  • We will add a query to the page to get all of the tours in our database
  • Type this code out the first time & show cfquery tag to talk about it
  • Recordsets are returned from the database as query variables
  • datasource attribute specifies data source to connect with (required)
  • name attribute identifies the result set in memory returned by the query
    <cfquery datasource="suma" name="qTours"> SELECT tourName, TourDescription, numberOfDays, Country FROM Tours ORDER BY Country </cfquery>
    Educator®

    Please sign in for full access to this lesson.

    Sign-InORCreate Account

    Enter your Sign-on user name and password.

    Forgot password?

    Start Learning Now

    Our free lessons will get you started (Adobe Flash® required).
    Get immediate access to our entire library.

    Sign up for Educator.com

    Membership Overview

    • Unlimited access to our entire library of courses.
    • Search and jump to exactly what you want to learn.
    • *Ask questions and get answers from the community and our teachers!
    • Practice questions with step-by-step solutions.
    • Download lesson files for programming and software training practice.
    • Track your course viewing progress.
    • Download lecture slides for taking notes.

    Use this form or mail us to .

    For support articles click here.