>
> 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?
Sure. But it is much easier to do it the other way around:
<cfquery name="myquery" dbtype="query">
select *
from the QofQResult
</cfquery>
<cfquery datasource="mydsn">
SELECT thedate
FROM datetable
WHERE thedate || '_fr.htm' IN <cfqueryparam list="yes"
cfsqltype="cf_sql_date" value="#ValueList(myquery.thedate)#">
</cfquery>
Just make sure that datetable.thedate actually has the format of a
yyyymmdd string (use the databases native string formatting functions
if necessary).
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
