> Perhaps I spoke too soon...I just remembered an "unsolved mystery" with
> our CF servers relating to an occasional JDBC error involving
> CF_SQL_NUMBER and a numeric field in oracle.
>
>
>
> Thanks for the tip!
>
>
>
> Stace
Stace,
How did you resolve the issue? I think I'm having the same problem.
>
>
> _____
>
> 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]
