here is my task
In my table I have a date and in my folder I have files that are name with a date format like yyyyddmm.htm What I am trying to do is only return the rows where the file exists in my directory.
Does that make sense?
----- Original Message -----
From: Schuster, Steven
To: CF-Talk
Sent: Tuesday, January 13, 2004 2:35 PM
Subject: RE: Sub Query of a QofQ
Though this seems like a stupid question why not just use a left outer join?
Of course I didn't see any code as I must have deleted the original so this
may all be moot.
Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101
Office Phone 606.920.7447
Cell Phone 606.831.4590
_____
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:29 PM
To: CF-Talk
Subject: Sub Query of a QofQ
Hi
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?
What I am getting at is
<cfquery datasource="mydsn">
Select thedate from datetable where thedate in (select * from the
QofQResult)
</cfquery>
How would you get the above to work?
Thanks
Mike
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
