>
> 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]
