Hi Jochem, > Which ODBC and JDBC driver are you using? I'm using the PostgreSQL Unicode driver that comes with the 8.2.5 install. I'm using postgresql-8.2-506.jdbc3.jar that comes with 8.2.5 as well.
> Have you changed the prepare threshold for the JDBC driver? No. I know little about JDBC, so I will look into this. > What do you get from the following three queries through JDBC and ODBC: > 1. SELECT CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TEXT); > 2. SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITH TIME ZONE) AS TEXT); > 3. SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITHOUT TIME ZONE) AS TEXT); ODBC: 1. 2007-09-27 11:59:16.135 2. 2007-09-27 11:59:16.135-04 3. 2007-09-27 11:59:16.135 JDBC: 1. 2007-09-27 12:03:01.633000 -04:00:00 2. 2007-09-27 12:03:01.742-04 3. 2007-09-27 12:03:01.742 Thanks Andrew -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 26, 2007 3:52 PM To: CF-Talk Subject: Re: CF 7 and postgresql odbc/jdbc issue Andrew Clark wrote: > CF 7.0.2 Standard, PostgreSQL 8.2.5 > When going through ODBC cf_sql_timestamp is able to use functions that > have arguments of type 'timestamp without time zone', but when going > through JDBC cf_sql_timestamp requires the function argument type to > be 'timestamp with time zone'. Which ODBC and JDBC driver are you using? Have you changed the prepare threshold for the JDBC driver? What do you get from the following three queries through JDBC and ODBC: SELECT CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TEXT); SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITH TIME ZONE) AS TEXT); SELECT CAST( CAST(<cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp"> AS TIMESTAP WITHOUT TIME ZONE) AS TEXT); Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
