Data Retrieval and Manipulation in Macromedia ColdFusion 5

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

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
285 Minutes

Objectives:

Data Retrieval and Manipulation in Macromedia ColdFusion 5

  • describe how to use form data in queries.
  • demonstrate how to use text and list searches in ColdFusion 5.
  • use form data in queries in ColdFusion 5.
  • describe how to build a drill-down interface in ColdFusion 5.
  • create a data drill-down in ColdFusion 5.
  • insert data into a database in ColdFusion 5.
  • build an insert action page in ColdFusion 5.
  • update a database.
  • describe how to use server-side validation and scripting languages to validate data in ColdFusion 5 forms.
  • use server-side validation in ColdFusion 5.
  • use ColdFusion 5 to implement client-side validation.
  • describe web statelessness, and use the Application.cfm file to enable the ColdFusion 5 application framework.
  • use HTTP cookies.
  • store information about each session in a ColdFusion application using session variables.
  • use session variables to secure application pages.
  • lock shared variables.


    • Course Number: 62163_eng