Advanced ColdFusion Training: Session 2

In this session, we dug into creating and manipulating lists and queries more in-depth, including the various functions available for working with each, looping over them, creating queries from “thin air”, and queries of queries. We also looked performing loops over date/time and working with , then finished by studying how to read files into ColdFusion and then using this to read in existing delimited data files and processing them for use in an application. This session was first conducted on June 18, 2009 and took 2.5 hours, not including the practice section.

Table of Contents:

Part 1: Lists

  • Creating Lists
  • List Functions
  • Looping

Part 2: Queries

  • Query Functions
  • Referencing Queries
  • Grouping Query Output
  • Query of Queries

Part 3: Transactions

Part 4: Data Importing With CFFILE

  • Uploading Files
  • CFFILE Variables
  • Parsing a Data File

Best Practices and Reminders

Applying What We Learned

Download the 22 page PDF

Ye ol' disclaimer: These sessions are not exact copies of the Adobe materials. I sometimes combine units, removed all “homework”, removed all the Dreamweaver dependent stuff, occasionally reorder the content order, and I rewrite large chunks and add in my own materials where I feel necessary/relevant. As such, any errors here are likely mine. I did, however, retain some of their example images and some of their basic example code and queries (in which case, errors may also be theirs).