> > Ok, I have multiple queries. I have to have multiple queries to massage the > data differently for some of the columns. I want to combine all those > queries into one table or cfgrid. How do I do that? >
Check out the Query...() functions such as QueryNew(), QueryAddColumn() and etc. The other option to consider is to use SQL Server (or whatever your back-end database is) to do the heavy-lifting data manipulation. It is usually much faster, and tends to create cleaner code. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4