ColdFusion MX: Level 2

Code:

 ZD85-582

Series:

 Information Technology

Duration:

 1 day
Database-Driven Web Sites
Planning
Database Connections
Retrieving Data from the DB Connection
The <CFQUERY> Tag
SQL SELECT Statements
<CFOUTPUT> for RecordSet Data
Enable Debugging Output
Querying a Query
Query Meta-Information

Data Drill-Down Applications
Planning
Boolean Logic in SQL Statements
Queries with JOINs
Selections with Duplicate Field Names
Output Images Dynamically

Displaying Data Subsets
RecordSet Navigation Scheme
Paging Applications
The maxrows Attribute
The startrow Attribute
The <CFPARAM> Tag
The Evaluate() Function
Next and Previous Record Management
Format Data Output		 Search Features
Components for Search System
Dynamic Search Form
Dynamic Search Results Template
Variable Scope
The IsNumeric() Function
"No Records Found" Handling
Single-keyword Search Functionality
SQL Text Operators
Multiple-keyword Search Functionality
Lists
The ListLen() Function
Looping

Re-Usable Code
User-defined Functions
The <CFFUNCTION> Tag
<CFSCRIPT>
The Function Keyword
Custom Tags
Tag Documentation
Tag Encoding
Tag Storage Locations

ColdFusion MX: Level 2

Course specifications
Course number: 085-582
Software version number: 6.1
Course length: 1 day

Course description

Overview:
Students taking this course should be experienced with HTML, Internet concepts, SQL fundamentals, and database fundamentals. This course introduces students to the syntax, functions, tags, and possible development solutions they're likely to encounter as they begin to develop database-driven ColdFusion applications.

Prerequisites:
This course is designed for the experienced computer user who has an understanding of Internet functionality and fairly extensive experience with HTML. The target student should also understand database and SQL basics. We strongly recommend that all students considering this course should first take ColdFusion MX: Level 1. Many vital concepts are omitted from this book because they were covered in Level 1 of this course series. A student who is not experienced with HTML and ColdFusion fundamentals, should take the following InterSkill courses before proceeding with this course:

  • HTML 4.0 Level 1
  • HTML 4.0 Level 2
  • SQL Fundamentals
  • ColdFusion MX: Level 1

Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Students will learn how to create dynamic Web sites that interact with databases and user input.

What's next:
ColdFusion MX: Level 2 is the second and final course in this series.

ColdFusion MX: Level 2

Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. The concepts and tasks in this book are designed to provide the student with the skills necessary to create a variety of applications, in addition to the specific applications they'll create. Upon successful completion of this course, students will be able to:

  • Create dynamic tables to output query results, apply date functions to create a date stamp, and implement a drill-down application.
  • Create an application that updates existing database records and records the date and time of modifications.
  • Create an application that inserts new records and another that deletes existing records.
  • Enable form field validation with a variety of methods, and re-populate a form with submitted data.
  • Create a keyword search application that can handle a variety of user criteria.