A demonstration of what can be accomplished with a database through cfm design.

Download the zip file or Reset the database.

The Road to Enlightenment

These are examples written by Phillip Senn showing how to use ColdFusion.

Your data tables are: dbo.TempState1, dbo.TempCity1, and dbo.Division.

So What is This About?

Subject Garden Name Category Description
cfquery   Getting data from the database
  001 cfquery   Header/Detail maintenance
  002 dbtype="query"   Query of Queries
  003 CreateObject   Making a library of queries
cfoutput    
  004 group   States group by Division
    cffunction   Putting a query into a function
    cftry   Catching database errors
    cfreturn   Returning more than 1 value
    metadata   Information about the query
  ??? Navigator
    ClientSideDatabase
         
Scope   The lifespan of variables
  005 url   hyperlinks
    form   form action="post"
    cgi   Info about the request
    query   Query result plus more info
    Application Persistent Global to all pages, all users
    session Persistent Global to all pages per user
    request   Global to the http request
    Variables   local to the cfm page
    Variables   local to the cfc component
    arguments   Parameters passed to the function
    var local   local to the function
    cfcatch   Error trapping
    this   Used to cache the program into a scope
    thisTag   Custom Tags
    attributes   local to the custom tag
    attributeCollection   Passing a structure to a custom tag
    Cookie   Not used.
    client Persistent Not used.
    Server Persistent Not used.
    cflogin   Not used.
    cfthread   Not used.
    ArgumentCollection   Not used.
Conditionals    
    IF/Then    
    IF/Then/Else    
    Switch    
         
Looping    
    Incrementing   From 1 to the number of States
    List   Looping through a list
    Collection   Looping through the form scope
    Condition   While condition
    cfbreak   Breaking out of a loop
         
         
     
    isDefined   Determine if a scope exists
    structKeyExists   Determine if a variable exists within a scope
         
         
         
         
         

Participation

Strong CFM skills aren't necessary.

Paragraph 2.

Paragraph 3.

Benefits

One day this gallery will be a historical curiosity; that day is not today.

Requirements

Requirements paragraph 1

Requirements paragraph 2

Requirements paragraph 3

Requirements paragraph 4.

ColdFusion 8 graciously donated by Hosting.com.