Cold Fusion Schedule

If you miss a class, please check on the web for the most recent schedule. 

Date	Topics	Reading related to Topics/Homework Due on Wednesdays
Aug. 26, 28	Class Organization Textbook website Student email instructions Web Servers, IP addresses,  ports Installing Cold Fusion MX Server Creating a Single Table Database in Microsoft Access Queries in Design Mode for Single Table Databases Relational (Multiple Table) Databases and normalization Creating Relationships in Access Queries in Design Mode for Multiple Table Databases Where Relationship Exists	Assignment 1: Installing Cold Fusion Server, Appendix A, Chapters 1-2
Sept. 2 (holiday), 4	registration database SELECT, UPDATE, INSERT, AND DELETE Queries in SQL SQL Mode in Access	Chapters 5,6 (skip Chapters 4 and 7 for now - they concern Dreamweaver MX)
Sept. 9, 11	Accessing the CF Administrator Adding a Virtual Web Mapping Creating a Data Source in Cold Fusion Administrator - Windows 98/ME issue CF Templates CF Functions CF Variables CF Expressions, Data Types	Chapter 3, 8
Sept. 16, 18	Conditional Statements Loops Data-Driven Pages Displaying Database Query Results Query Variables Data Drill-Down Code samples: ch9-1.cfm, ch10-1.cfm, ch10-2.cfm, ch10-3.cfm, ch10results.cfm, ch10details.cfm Database Connection Errors	Ch. 9, 10
Sept. 23, 25	Forms Code samples - ch11-1.cfm (search form) tryagain.cfm, ch11details.cfm (receives input from search form and does search)	Database Assignment, Ch 11
Sept. 30, Oct. 2	Form Data Validation - Embedded Form Validation code, Client-Side Validation with <cfinput> code Using Forms to Add or Change Data	Ch. 12, 13
Oct. 7, 9	Midterm and Review of Midterm Form, Action code - SQL insert Form, Action code - <cfinsert> Form, Action code - SQL update Form, Action code - <cfupdate>	Search Forms Assignment, Ch. 14
Oct. 14 (no class -holiday), Oct. 16	Application.cfm - Sample code Customizing Error messages - sample code for request template, exception template, header, page with errors  Using Application variables Using Locks Application Variable timeouts	Fix Midterm Assignment, Ch. 15-16
Oct. 21, 23	Cookies - Code to set and read Client variables - Code for Form and set/use (CF sets cookie) Clent variable - Code for Form and set/use (client prohibits cookie) Session variables - Code for Form and set/use	Ch. 17
Oct. 28, 30	Security - "Homegrown security" code samples:  page to be password protected force login login form login check database with security info	Ch. 18
Nov. 4, 6	User Defined Functions - example 1, example 2 Custom Tags - coolimage.cfm, example of use (coolimage coded so that it only works in Netscape), ch20add.cfm, example of use Alternatives to using CFAdmin or special server files	Ch. 19, Ch. 20
Nov. 11	Cold Fusion Components  Sample Component cfinvoke with no parameters cfinvoke with parameters Creating Instance with cfobject Invoking Method (Script Syntax) Using Instance Data as Property with next page showing instance doesn't last Putting Instance in Application Scope with next page showing instance lasts Link to CFC to document and execute method	Ch. 20
Nov. 13	Improving the User Experience - Default behavior for long running pages, behavior with cfflush Improving Performance - Caching Queries, Flushing After Update, Caching Pages	Ch. 21, 22
Nov. 18, 20	Graphing - Single Series code Multiple series code Drill Down chart and detail page Writing Chart to File using cffile,  displaying content with cfcontent Using file with cfcontent as src attribute of img tag	Ch. 25
Nov. 20, 25	Reading Headers, Entire Message with Cold Fusion	Ch. 26
Dec.2	Sample Database to Send Mail Simple Sending Sending email with inline images and  attachments
Dec. 4	Online Commerce Cold Fusion Server Configuration (esp. archives, sandbox security) More about SQL and Queries	Ch. 27, Ch. 28, Ch. 29
Dec. 9	Aggregate, Group By Example Creating a View Example Query of Queries Example Parameterized Query Example Form & Action (cftransaction)
Dec. 11	Using cftry & cfcatch with cfabort Using cftry & cfcatch and then cfif for dependent code Putting dependent code inside cftry Nesting code within two cftry tags Alternative way of nesting Throwing and catching own error	Ch. 31
Dec. 18 (optional class)	Creating & Indexing a Collection of Files Programmatically Form and Action Pages for  Searching Documents Creating & Indexing a Database Programmatically Form and Action Pages for Searching Databases using Verity	Project

Revised: December 18, 2002; Comments to William M. Pegram, wpegram@erols.com