I'm working with a mixture CF 4.5.1SP2 and CF5 servers pointint to an Oracle
8i database. I'm currently in the process of migrating completely to CF5,
but in the meantime I need to ensure that all my code is the same and works
the same in both environments.
I'm finding an issue with how 4.5 and 5 treat DATE columns using
CFQUERYPARAM.
I have the following (snippet) in one of my queries:
AND
AUTHORIZATION_EMAIL_NEXT_DATE < <cfqueryparam
cfsqltype="CF_SQL_DATE" value="#CreateODBCDate("10/31/2002")#">
In CF4.5 this throws an error: CFQUERYPARAM data conversion error
This same error also occurs if I change the CFSQLTYPE to CF_SQL_TIMESTAMP or
remove the CreateODBCDate().
However, in CF5, it doesn't throw an error and everything seems fine.
In CF4.5 I'm using a third-party (Data Direct) ODBC driver, while in CF5 I'm
using the Oracle driver that came with it.
Does anybody have any insight? Am I going to have to forget the CFQUERYPARAM
in this case and just do AUTHORIZATION_EMAIL_NEXT_DATE <
#CreateODBCDate("10/31/2002")# , at least until I get everyone up to CF5?
--
Al Everett
Allied Office Products
www.askallied.com
mailto:aeverett@;askallied.com
v: 973-594-3209
f: 973-594-3626
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
