Ade
-----Original Message-----
From: Sandy Clark [mailto:[EMAIL PROTECTED]
Sent: 09 December 2003 13:41
To: CF-Talk
Subject: RE: I Hate QoQ
How can you QofQ a query of the same name as the one you are executing?
<cfquery dbtype="query" name="involved"> <--- Name of Query
SELECT isPublic FROM involved <--- Name of query you are taking
from.
Change one, I'll bet your problem goes away.
_____
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 4:55 PM
To: CF-Talk
Subject: I Hate QoQ
So any idea why this very simple QoQ won't work?
<!---- filter query ---->
<cfquery dbtype="query" name="involved">
SELECT isPublic FROM involved
WHERE isPublic = 1
</cfquery>
isPublic is a valid column name, and the values are either 0 or 1.
This is the error I get:
Query Of Queries runtime error.
Unsupported Date type conversion in Query of Queries.
I've tried the follow too in case some reason it converted to string,
but alas same error:
<!---- filter query ---->
<cfquery dbtype="query" name="involved">
SELECT isPublic FROM involved
WHERE isPublic = '1'
</cfquery>
Any ideas?
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
