that creates the query, I put together one and I can QofQ it as normal.
Ade
-----Original Message-----
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: 09 December 2003 16:00
To: CF-Talk
Subject: RE: I Hate QoQ
Yup. Still got there error. If you noticed in my message even a query
without a WHERE clause throws the error!
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-----Original Message-----
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:47 AM
To: CF-Talk
Subject: RE: I Hate QoQ
SInce you're creating the query yourself with CF and CF doesn't care
about dataatypes, have you tried using single quotes around the
qualifier in your SQL? Perhaps the column you're selecting from isn't an
int datatype in this case and needs the quotes. (Just a guess)
<cfquery dbtype="query" name="involved">
SELECT isPublic FROM involved
WHERE isPublic = '1'
</cfquery>
Greg
-----Original Message-----
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:44 AM
To: CF-Talk
Subject: RE: I Hate QoQ
The dump shows everything as expected:
query
COURSEID
ENDDATE
FACULTY
ISPUBLIC
OFFERINGID
STARTDATE
TITLE
URL
USERLEVEL
1
103
2003-12-19 00:00:00.0
Segui-Gomez
1
111
2003-10-27 00:00:00.0
Confronting the Burden of Injuries
http://distance.jhsph.edu/burden/ <http://distance.jhsph.edu/burden/>
60
2
83
2003-12-19 00:00:00.0
Reinke, Tayback
1
105
2003-09-02 00:00:00.0
Health Administration Statistics
http://distance.jhsph.edu/has/ <http://distance.jhsph.edu/has/>
60
I think the issue may be that this query is hand-rolled in CF with
queryNew() and querySetCell() rather than coming directly from a
datasource. Regardless of whether I treat isPublic as numeric or string
I get the error. Are there any know issues with using query of query
with a query created in CF?
Being that I create the query myself there is now way for isPublic =
NULL.
The following query throws the same error, even without a WHERE clause!
<cfquery dbtype="query" name="involved">
SELECT * FROM involved
</cfquery>
As for naming the QoQ after the same query I am querying, I've used this
method before to filter queries without problem. Just to be sure however
I've chanced the query name to be separate from the new query.. still
got the error.
So I'm getting the feeling that you can't run a QoQ on a query that CF
created.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 4:54 PM
To: CF-Talk
Subject: RE: I Hate QoQ
whats a cfdump of the original query return?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
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 ---->
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]
