I don't want to beat a dead horse, but query objects are very useful and
don't have to come from DB queries.  In cfQuickDocs, I manually create a
query object from the data I get from livedocs.  Then for the
function/tag searches I just do QofQ on the query object.  And none of
cfQuickDocs ever touches a database.  :-) 

> -----Original Message-----
> From: Andy Matthews
> Sent: Wednesday, March 22, 2006 7:57 AM
> 
> Really? I knew that it returned a query object, I just didn't 
> think you
> could query against that again. Very cool.
> 
> -----Original Message-----
> From: Ken Ferguson
> Sent: Wednesday, March 22, 2006 8:58 AM
> 
> 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.
> 
> Andy Matthews wrote:
> > He's not talking about database query folks.
> >
> > He's using cfdirectory to get a directory structure.

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235973
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

Reply via email to