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]
