our CF servers relating to an occasional JDBC error involving
CF_SQL_NUMBER and a numeric field in oracle.
Thanks for the tip!
Stace
_____
From: Doug Keen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 08, 2004 2:19 PM
To: CF-Talk
Subject: Re: Cold Fusion and Oracle
I've had similar issues when migrating a CF/Oracle app from CF 4.5 to CF
6.1. During that adventure I found this resource:
http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
This chart maps CF_SQL_TYPE's to types specific to different database
platforms, including Oracle. In your case, you might have some luck if
you change you CF_SQL_NUMBER parameters to CF_SQL_FLOAT (it worked for
me, and as that chart shows, it's a better match for Oracle's "NUMBER"
type).
Doug Keen
Senior Consultant, The Seva Group
http://www.sevagroup.com
Phone: 443-703-2087
Fax: 443-703-2097
Toll-Free: 1-888-230-1576
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
