Query of Queries would work really well, and would be very efficient ... why not do that?
Query 'employees' has: firstName, lastName, title, email, phone, ext <cfquery dbtype="query" name="employees"> SELECT firstName, lastName, email FROM employees </cfquery> That would get you there with very little overhead ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:323038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
