query of queries (cfquery) can add them together, but you might need to know which query each came from.
select * from q1 union select * from q2 will add them together. If you need to know the query (or folder) it came from, you can add a column to each query with the info of the query name (QueryAddColumn()) before doing the union. There might be a better way, but I've done this before On 3/21/06, Oleg Gunkin <[EMAIL PROTECTED]> wrote: > cfdirectory returns a query as a result, and I need somehow to combine > results of several cfdirectory calls. In other words, I have two queries, but > I need to combine them into a single query. Any ideas how to do that? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
