RE: I Hate QoQ
Try casting the isPublic from the original query into an int. Select Cast(isPublic as int) as isPublic _ From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:00 AM 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) SELECT isPublic FROM involved WHERE isPublic = '1' 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/ 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/ 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! SELECT * FROM involved 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? 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
I'm not sure if you posted it already, but could we get a look at your code 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) SELECT isPublic FROM involved WHERE isPublic = '1' 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/ 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/ 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! SELECT * FROM involved 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? 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
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) SELECT isPublic FROM involved WHERE isPublic = '1' 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/ 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/ 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! SELECT * FROM involved 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? 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
Thanks, helps getting my head around how it works. Steve -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 10:47 AM To: CF-Talk Subject: RE: I Hate QoQ Try it for yourself, it does overwrite it. 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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
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) SELECT isPublic FROM involved WHERE isPublic = '1' 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/ 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/ 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! SELECT * FROM involved 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? 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
Just for quell and speculation the following query throws the error: SELECT * FROM involved 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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
Try it for yourself, it does overwrite it. 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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
No it's def doable. I actually do it all the time to save variable namespace. I'm not an expert but I assume that it creates an instance of query then overwrites the original query when it's completed. 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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
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/ 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/ 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! SELECT * FROM involved 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
I had some trouble getting QofQ to work with bit data types way back when. I don't think we ever resolved it and just went to tinyint in the db. Has anyone ever gotten bit datatypes to work in QofQ? Is there some work around? Thanks, -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:29 AM To: CF-Talk Subject: Re: I Hate QoQ Adam Wayne Lehman wrote: > So any idea why this very simple QoQ won't work? > > > > SELECT isPublic FROM involved > WHERE isPublic = 1 > > > 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. Probably the ugly under-the-hood typeacsting again. How about trying for a boolean: SELECT isPublic FROM involved WHERE isPublic = TRUE Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
How can you QofQ a query of the same name as the one you are executing? <--- 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
Re: I Hate QoQ
Adam Wayne Lehman wrote: > So any idea why this very simple QoQ won't work? > > > > SELECT isPublic FROM involved > WHERE isPublic = 1 > > > 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. Probably the ugly under-the-hood typeacsting again. How about trying for a boolean: SELECT isPublic FROM involved WHERE isPublic = TRUE Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I Hate QoQ
Did you double check (CFDUMP) that all the values are numeric and/or string? CF recordsets aren't strongly typed, but the comparisons are. Most of the problems I've had are because one field in one record has an ambigious type, and it screws everything up. Also, I'm not sure passing '1' is going to make it a character comparison. The sql interpreter might convert it to numeric behind the scenes, before the query is run. Cheers, barneyb > -Original Message- > From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] > Sent: Monday, December 08, 2003 1:55 PM > To: CF-Talk > Subject: I Hate QoQ > > So any idea why this very simple QoQ won't work? > > > > SELECT isPublic FROM involved > WHERE isPublic = 1 > > > 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: > > > > SELECT isPublic FROM involved > WHERE isPublic = '1' > > > 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]
RE: I Hate QoQ
Column is numeric? Try it with a cfqueryparam and set to varchar and see if it works... Stace _ 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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
RE: I Hate QoQ
Problem is that you are querying the query you are creating (name="involved" and you're selecting from involved). -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, 08 December, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
Re: I Hate QoQ
and you're absolutely sure that the query you are querying returns a 1 or 0 for isPrivate (show us the dump of the first query)? Could isPrivate ever be NULL? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Adam Wayne Lehman To: CF-Talk Sent: Monday, December 08, 2003 1:54 PM Subject: I Hate QoQ So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
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? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
I Hate QoQ
So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 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: SELECT isPublic FROM involved WHERE isPublic = '1' 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]
