This is report that I am creating is not really hit by many people is it for a small number of clients.
What you said makes sense just one thing. In the myquery.thedate value I will have a filename that is yyyymmdd_fr.htm can I look at just the date in your example?
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, January 13, 2004 2:41 PM
Subject: Re: Sub Query of a QofQ
Mickael said:
>
> Is it possible to have a simple query have a sub query using QofQ.
> It sounds like it could work but how do you determine the
> datasource?
Not as a subquery, but there are workarounds as long as the subquery
is not correlated. Just don't expect stellar performance.
> <cfquery datasource="mydsn">
> Select thedate from datetable where thedate in (select * from the
> QofQResult)
> </cfquery>
>
> How would you get the above to work?
Closest you can get will be:
<cfquery name="myquery" dbtype="query">
select *
from the QofQResult
</cfquery>
<cfquery datasource="mydsn">
Select thedate
from datetable
where thedate in <cfqueryparam list="yes" cfsqltype="cf_sql_date"
value="#ValueList(myquery.thedate)#">
</cfquery>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
