QoQ bug? Help rqd...
Can someone else try running this little bit of code please: SELECT * FROM newQ If I run it on my window dev box, it works fine. If I run it on a linux dev box (RedHat 8), it works fine. If I run it on a live box (RedHat 7.3) it fails on the QoQ saying : Query Of Queries runtime error. Can't convert the string Thu 29 Jan to java type DATE All three boxes are running 6.1. Any ideas? Tim. --- Try the ColdFusion Coding Contest! Current contest: Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QoQ bug? Help rqd...
Tim, I had the same problem. It appears that even though CF variables are untyped, the underlying java expects properly formatted dates (java is a strongly typed language). You can use the ParseDateTime() function to convert your date into a timestamp. Here's your code with the work-around that I used: SELECT * FROM newQ HTH -- Michael Wolfe [EMAIL PROTECTED] _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 8:15 AM To: CF-Talk Subject: QoQ bug? Help rqd... Can someone else try running this little bit of code please: SELECT * FROM newQ If I run it on my window dev box, it works fine. If I run it on a linux dev box (RedHat 8), it works fine. If I run it on a live box (RedHat 7.3) it fails on the QoQ saying : Query Of Queries runtime error. Can't convert the string Thu 29 Jan to java type DATE All three boxes are running 6.1. Any ideas? Tim. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QoQ bug? Help rqd...
> I had the same problem. It appears that even though CF > variables are untyped, the underlying java expects properly > formatted dates (java is a strongly typed language). Yes, all java vars need to be typed, but it seems strange that CF seems to think that the string is a date, tries converting it and fails. > You can use the ParseDateTime() function to convert your date > into a timestamp. Unfortunately the problem was that I *didn't* want it to be a date, just a string that happened to be formatted to look like a date... Ho hum, I got around the problem, but it just seems strange that the problem should occur on one installation and not others... :o\ Tim. --- Try the ColdFusion Coding Contest! Current contest: Maze Solver - http://tech.badpen.com/cfcontest/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: QoQ bug? Help rqd...
I had the same problem as well! QofQs was changing a comma delimited list of numbers into a date, even though I wanted it as a string! I found it was when I did multiple QofQs. I was able to reduce the number of QofQs by changing some of the initial SQL code and it went away. how annoying! --- Exciteworks -- expert hosting for less! http://exciteworks.com specializing in reseller accounts Tim Blair wrote: > > I had the same problem. It appears that even though CF > > variables are untyped, the underlying java expects properly > > formatted dates (java is a strongly typed language). > > Yes, all java vars need to be typed, but it seems strange that CF seems > to think that the string is a date, tries converting it and fails. > > > You can use the ParseDateTime() function to convert your date > > into a timestamp. > > Unfortunately the problem was that I *didn't* want it to be a date, just > a string that happened to be formatted to look like a date... > > Ho hum, I got around the problem, but it just seems strange that the > problem should occur on one installation and not others... :o\ > > Tim. > > --- > Try the ColdFusion Coding Contest! Current contest: > Maze Solver - http://tech.badpen.com/cfcontest/ > --- > RAWNET LTD - Internet, New Media and ebusiness Gurus. > WE'VE MOVED - for our new address, please visit our > website at http://www.rawnet.com/ or call us any time > on 0800 294 24 24. > --- > This message may contain information which is legally > privileged and/or confidential. If you are not the > intended recipient, you are hereby notified that any > unauthorised disclosure, copying, distribution or use > of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, > information or conclusions expressed in this message > are those of the originator, not of rawnet limited, > unless otherwise explicitly and independently indicated > by an authorised representative of rawnet limited. > --- > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
