Really? I knew that it returned a query object, I just didn't think you could query against that again. Very cool.
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 8:58 AM To: CF-Talk Subject: Re: Merging two queries So what? It still returns a query object. <cfdirectory action="LIST" directory="c:\" name="d1"> <cfdirectory action="LIST" directory="d:\" name="d2"> <cfquery name="q" dbtype="query"> Select * From d1 UNION Select * from d2 </cfquery> <cfdump var="#q#"> This works just fine. --Ferg Andy Matthews wrote: > 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:235958 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
