<cfquery name="foo" dbtype="query">
select * from query1
union
select * from query2
</cfquery>
????
Doug
-----Original Message-----
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:33 PM
To: CF-Talk
Subject: RE: Concatenating Queries
I've got two queries created from CF (queryNew()).
I want to get these two queries into a third query.
<cfset query1=queryNew('documentID, documentName')>
<cfset queryAddRow(query1)>
<cfset querySetCell(query1, 'documentID', 1)>
<cfset querySetCell(query1, 'documentName', 'test1')>
<cfset query2=queryNew('documentID, documentName')>
<cfset queryAddRow(query2)>
<cfset querySetCell(query2, 'documentID', 2)>
<cfset querySetCell(query2, 'documentName', 'test2')>
<cfset queryAddRow(query2)>
<cfset querySetCell(query2, 'documentID', 3)>
<cfset querySetCell(query2, 'documentName', 'test3')>
<cfset query3=queryNew('documentID, documentName')>
Will a UNION work in a dynamic query? If so do you have an example.
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:34 PM
To: CF-Talk
Subject: Re: Concatenating Queries
Union?
----- Original Message -----
From: "Bryan F. Hogan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 12:23 PM
Subject: Concatenating Queries
> Does anyone know of an easy way to concatenate two queries?
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
