> Don't feel bad, Patrick. Every so often, I run the idea around that we
> should collapse all variables into a single scope. People generally think
> I've lost my mind, so I slink back into the woodwork for a few more
> months...
I happen to think that's an excellent idea. See ya in the asylum. :)
> What do you do when you get queries with multiple rows?
In theory...
<cfquery name="temp" ...>...</cfquery>
<cfset attributes['myQuery'] = temp>
<cfset temp="">
In practice...
<cfquery name="myQuery" ...>...</cfquery>
In rare cases...
<cfquery name="temp" ...>Select aSingleField from aTable</cfquery>
<cfset attributes['aList'] = ValueList(temp.aSingleField)>
<cfset temp="">
Patrick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
