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
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).