On Wed, Jul 14, 2010 at 10:54 AM, DURETTE, STEVEN J (ATTASIAIT) <sd1...@att.com> wrote: > Correct me if I'm wrong (please) but isn't a query already a Struct of Arrays?
It is, but you can really only use that to select data based on a column name and row number. Typically, if I were to convert a query to a struct and then use that struct, the key of the struct might be something like the PK of the data, such as userID. This means you could look up a value in the struct like this: #myStruct[variables.userID].firstName# If you leave your resultset as a query, you cannot look up an individual row without knowing it's row number. Which makes "it's a struct of arrays" pretty useless if all you know is the user's ID. -Cameron -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: camer...@gmail. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm