Ah, my problem there was that the queries could contain different fields and different numbers of fields. The only definites are the Date and a record number unique to the query. So one big master query was technically out of the question. I did however end up using a query of queries to pull and sort just the unique number, the date, and a custom "whichQuery" field from each query. Then when outputing that QofQ, I could run another QofQ using the unique number and "whichQuery" to get the rest of the data for that record from the associated original query.
On Tuesday, July 10, 2012 1:02:50 PM UTC-4, websolete wrote: > Not to beat a dead horse, since you seem to be happy with your solution, > but if elegant is a goal I would have gone with merging all the queries > into a single query inside the cfc, then queryOfQuery it for the sort you > wanted, returning the merged master query as a single entity, as that's > about as simple as you can get to work with for output. > -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
