If they're coming from the same datasource, try using a UNION query to
have the database return the two recordsets as one.
If they're coming from different datasources, you could probably still
UNION them inside a query of queries.
-joe
----- Original Message -----
From: Tony Weeg <[EMAIL PROTECTED]>
Date: Tue, 20 Jul 2004 09:59:55 -0400
Subject: merge data from two queries
To: CF-Talk <[EMAIL PROTECTED]>
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.
--
tony
Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
Check out http://www.antiwrap.com to send websites to your
friends.________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
