The assignment must happen as the final process. You're assuming an empty
query is created and assigned to the query name, then the query is
populated, I doubt this is the case. It's more likely to be that the query
is returned in full then assigned to a reference.
Ade
-----Original Message-----
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: 09 December 2003 15:34
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]
