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:
<cfset variables.newQ = querynew("col1")>
<cfset queryaddrow(variables.newQ)>
<cfset querysetcell(variables.newQ, "col1", ParseDateTime("Thu 29 Jan"))>
<cfdump var="#variables.newQ#">
<cfquery name="variables.testQoQ" dbtype="query">
SELECT * FROM newQ
</cfquery>
<cfdump var="#variables.testQoQ#">
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:
<cfset variables.newQ = querynew("col1")>
<cfset queryaddrow(variables.newQ)>
<cfset querysetcell(variables.newQ, "col1", "Thu 29 Jan")>
<cfdump var="#variables.newQ#">
<cfquery name="variables.testQoQ" dbtype="query">
SELECT * FROM newQ
</cfquery>
<cfdump var="#variables.testQoQ#">
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]
