Hi All, I'm having an issue but I'm not sure whether it's an Coldfusion issue or PostgreSQL issue.
I have an existing server running CF 7.0.2 Standard, connecting to PostgreSQL 8.2.5 through an ODBC connection. When I switch the datasource to a JDBC connection, I get errors about missing functions. I've tracked down the issue down to the cfsqltype = cf_sql_timestamp 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'. Is this a Coldfusion issue, or a PostgreSQL issue? In general, does Coldfusion determine what the underlying DB types are, or does it just use a generalized type and the jdbc/odbc driver determine the type? Thanks, Andrew ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289496 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
