Yes it is, and so query of query will work fine.
<cfdirectory action="read" name="q1" ...>
<cfdirectory action="read" name="q2" ...>
<cfquery name="q3" dbtype="query">
select * from q1
union
select * from q2
</cfquery>
> It's still a query object that is returned though, right?
> --
> Tim Heald
> [EMAIL PROTECTED]
> 703-300-3911
> -----Original Message-----
> From: Andy Matthews [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 22, 2006 9:40 AM
> To: CF-Talk
> Subject: RE: Merging two queries
> He's not talking about database query folks.
> He's using cfdirectory to get a directory structure.
> <!----------------//------
> andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --------------//--------->
> -----Original Message-----
> From: Andy Neale [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 22, 2006 8:22 AM
> To: CF-Talk
> Subject: Re: Merging two queries
> UNION them in a query-of-queries.
> --
> Andy
> Andy Matthews wrote:
>> Put them into an array or structure?
>>
>> <!----------------//------
>> andy matthews
>> web developer
>> ICGLink, Inc.
>> [EMAIL PROTECTED]
>> 615.370.1530 x737
>> --------------//--------->
>>
>> -----Original Message-----
>> From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, March 21, 2006 5:13 PM
>> To: CF-Talk
>> Subject: Merging two queries
>>
>>
>> cfdirectory returns a query as a result, and I need
>> somehow to combine
>> results of several cfdirectory calls. In other words, I
>> have two
>> queries, but I need to combine them into a single query.
>> Any ideas how to
> do that?
>>
>> --
>> Oleg Gunkin
>> Email: [EMAIL PROTECTED]
>> Phone: (604) 666-9392
>> Emerging Technologies / Pacific Web Services Information
>> Technology
>> Services Public Works and Government Services Canada
>> (Pacific)
>>
>>
>>
>>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
