Try using CF_SQL_TIMESTAMP as the type for dates... That's what I use and have no issues...
HTH -----Original Message----- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Wednesday, October 30, 2002 14:30 To: CF-Talk Subject: CF4.5/5 cfqueryparam differences 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
