Any idea how to do that in MySQL 5? On Fri, Nov 7, 2008 at 9:00 PM, Mike Chabot <[EMAIL PROTECTED]> wrote: > You can run a pivot command in your database query before sending the > results to ColdFusion so that CF receives the data in a format that > can be easily looped over. > > -Mike Chabot >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

