Re: Dates and Times as string with Infromix JDBC?

"Newt" <beparker@yahoo.com> schrieb im Newsbeitrag news:1112726451.619251.42280@l41g2000cwc.googlegroups.com... > We have a lot of legacy ColdFusion code that connects to Informix and > uses dates and times as strings. For example: > > SELECT > a.acct_id, > a.acct_code > FROM > sp_account a > WHERE > a.acct_create_date = "01/23/2005" > > is a query that worked fine in ColdFusion ( on Solaris ) using the > older ODBC drivers for Informis. We're upgrading to ColdFusionMX and > MX requires that we use JDBC drivers. I've downloaded and installed > the Informix JDBC 2.21.JC6 driver and now we can not use dates as > strings in queries - it wants us to create date objects. Who wants you to create date objects? ColdFusion? Who exactly complains when you try something like that? What is the error message? A statement like the one above can be still used in JDBC. I dont think this is your problem (ok, setting DBDATE the right way in the jdbc url might be necessary). Please give us more details. Regards, Dirk -- -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0 -- Hammer Str. 13 fax: +49 (0)251 28446-55 -- D-48153 Muenster http://www.GunCon.de/ -- "Toto, I don't think we're in Kansas anymore..."

Thanks for your reply, Dirk. The test box where I have ColdFusionMX installed is going through a restore right now - so I can't get the exact error. The error message said something about an invalid date as a string. But, I did some queries on your suggestion of DBDATE and from what I'm reading, it looks like that may solve the problem. After the server is back and I can try that, I'll either post a "It worked!" message or give you an exact error message. Thanks for your input. -BEP