In MX or 5.0 I'd use Query of queries.  However an ago (in the CF 4.5 days)
I did a challenge on this very topic.  The results are here:

http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challenge/Co
mbineSortQuery/Index.cfm

There's some interesting stuff in there - much of it still useful in the MX
world.

Jim Davis

From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 20, 2004 10:00 AM
To: CF-Talk
Subject: merge data from two queries

hello all...

if you wanted to take two queries, with like columns, and data that
needed to be merged, what would you do?

1. turn the query record set into a structure, and find the matching
keys, and merge the data?
2. turn the query record set into an array and do the same kinda thing?
3. or some other way?

just wondering.  im leaning towards making it a structure, and
manipulating that way.

later.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to