I am looping a query getting monthly numbers. Running the query getting the monthly numbers then outputting then to a variable then running the next month soon and so on,
here is a simplified version <cfloop from="1" to="12" index="ii"> Query <cfset "MTDPREV_"&ii = #MTD_PREV_REPORT.MTDPREV# /> </cfloop> what i want is MTDPREV_1 equals January totals MTDPREV_2 equals February and so on I'm sure it is something simple I am missing. Any help would be appreciated. Thanks Keith ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
