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:267201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
