Your suggestion makes sense. I am using access what do you mean by Native string formatting functions?
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Tuesday, January 13, 2004 3:00 PM
Subject: Re: Sub Query of a QofQ
Mickael said:
>
> 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]
