> Is there an easy way to do something like this? I also thought about the > possibility of building a new query instead of using an array, and then > using a query of queries to do the sorting.
Can you do something like left or inner join on the date? If all the tables have a date column, that would be a good starting point. Also, UNION is pretty flexible. By aliasing columns you can union almost anything. The more you can do in SQL the better, since it is set up to do joining, sorting and whatnot. It just gets more laborious if you have to start building structs/arrays/queries by hand. -- Josh ----- Original Message ----- From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, June 05, 2007 4:16 PM Subject: Sort array of structs on column? >I have a report to run where I query a number of different tables. I need > to sort the output by date, which means I need to consolidate the queries > and then sort the whole. I don't believe I can use a union, so I thought > I'd throw it all into an array of structs, which I'd sort afterwards. > > Is there an easy way to do something like this? I also thought about the > possibility of building a new query instead of using an array, and then > using a query of queries to do the sorting. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4