Data Retrieval and Manipulation in Macromedia ColdFusion MX


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To introduce and demonstrate data retrieval and manipulation in ColdFusion MX

Target Audience
Web professionals and developers that want to create dynamic web sites using ColdFusion

Prerequisites
Familiarity with web terminology; an understanding of web server characteristics; experience with the HTML tag set and syntax; familiarity with the SQL command set, including SELECT, INSERT, UPDATE, and DELETE

Expected Duration (hours)
4.2

Lesson Objectives

Data Retrieval and Manipulation in Macromedia ColdFusion MX

  • describe how to use form data in queries.
  • demonstrate how to use text and list searches in ColdFusion MX.
  • use form data in queries in ColdFusion MX.
  • describe how to build a drill-down interface in ColdFusion MX.
  • create a data drill-down in ColdFusion MX.
  • insert data into a database in ColdFusion MX.
  • build an insert action page in ColdFusion MX.
  • update a database in ColdFusion MX.
  • describe how to use server-side validation and scripting languages to validate data in ColdFusion MX forms.
  • use server-side validation in ColdFusion MX.
  • use ColdFusion MX to implement client-side validation.
  • describe web statelessness and use the Application.cfm file to enable the ColdFusion MX application framework.
  • use the CFLOGIN and CFLOGINUSER tags to create application-based security and log a user out of an application.
  • use the GetAuthUser() and IsUserInRole() functions.

    • Course Number:
    75377_eng