<!---- filter query ---->
<cfquery dbtype="query" name="myBrandNewQuery">
SELECT * FROM involved
</cfquery>
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-----Original Message-----
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:34 AM
To: CF-Talk
Subject: RE: I Hate QoQ
How can you overwrite a query that you are in the process of creating?
Wouldn't the cfquery tag overwrite an existing query before it got to
the
actual sql? In which case, wouldn't if have problems reading data from
a
query that is in "flux"?
Don't know why, but building a query like this just seems to look like
an
infinite loop to me because even if it did work, it would always be
selecting data from it's self.
Just my .02
Steve
-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 9:34 AM
To: CF-Talk
Subject: RE: I Hate QoQ
I'm not sure it is the problem, wouldn't it just overwrite the query?
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]
