Hi Tim, The best way to do this is to force CF to understand that you want to put a date in.
<cfset querysetcell(variables.newQ, "col1", CreateDate(2004, 01, 29))> This should do it... L. -----Original Message----- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 4:14 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] 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. ------------------------------------------------------- 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. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
