Troy, in CF 5 it would be a simple query-on-a-query. In 4.5 there's more
work involved. You need to create a new query variable using QueryNew, then
loop through your existing queries and use QueryAddRow and QuerySetCell to
populate the new query variable.
There may be a custom tag in the Alliare dev exchange that does this.
HTH,
Avi
At 04:09 PM 8/19/2001 -0400, Troy Simpson wrote:
>I have two queries result sets and would like to merge the data together
>using ColdFusion.
>What would be an approprate method to accomplish this task?
>I have ColdFusion Enterprise Edition 4.5.x
>
>Here is an example:
>
>I have one query result set like so:
>ID, author, ACCNO
>1, Jack, 2
>2, Mo, 4
>3, Emma, 6
>4, Sydney, 8
>5, Mary, 11
>...
>
>I have another query result set like this:
>ACCNO, Title
>1, "The board"
>2, "The walk"
>3, "The sand"
>4, "The beach"
>5, "The ocean"
>6, "The frost"
>7, "The building"
>8, "The house"
>9, "The grass"
>10, "The mud"
>11, "The car"
>...
>
>I want to join these two result sets so that I get a third query result
>set like this:
>ACCNO, Title, ID, Author
>1, "The board", ,
>2, "The walk", 1, Jack
>3, "The sand", ,
>4, "The beach", 2, Mo
>5, "The ocean", ,
>6, "The frost", 3, Emma
>7, "The building", ,
>8, "The house", 4, Sydney
>9, "The grass", ,
>10, "The mud", ,
>11, "The car", 5, Mary
>
>I know that in this example I could use the database to perform an outer
>join, but the real query sets are not comming from a database.
>Thanks in advance.
>
>Sincerely,
>Troy
>
>--
>Troy Simpson | North Carolina State University
>NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
>ph.919.515.3855 | fax.919.513.3330
>
>Some people change when they see the light.
>Others, when they feel the heat.
> -- corvis advertisement
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
