what do you get if you do this: <cfoutput> #isQuery(dataArray[1][5])# </cfoutput>
Is it really a query? If so, I'd suggest doing a <cfset myquery = dataArray[1][5]> and then querying that. QofQ wants the _name_ of a query, not the query itself. On 1/22/07, Peterson, Chris <[EMAIL PROTECTED]> wrote: > I have a report I am building that is getting 5 months worth of data. > Each month will be its own tab on an excel spreadsheet, and I like to > keep display / output separate from query / code, so I am cramming each > query result into an array. > > Well, I need to get a distinct list of pay classes from any of my 5 > query results, and just as a test I did a SELECT * FROM dataArray[1][5] > and CF gets PO'd about the [ in the query. Is this possible, or do I > need to get my queries new aliases, or should I just not store them in > an array? Maybe a structure instead? > > Chris > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
