I tried that. (Re-read my message.)
> -----Original Message-----
> From: Mike Townend [mailto:mike@;cfnews.co.uk]
> Sent: Wednesday, October 30, 2002 9:34 AM
> To: CF-Talk
> Subject: RE: CF4.5/5 cfqueryparam differences
>
>
> 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
