Interesting that I am having a null problem in CFML (not the driver)
with BlueDragon.
I have been on this list for years and don't recall any posts where DB
nulls were improperly handled by a driver or CFML. (there have been
issues with how to logically handle nulls).
But your issue and mine, both cause the program to crash.
Dick
On May 10, 2004, at 6:12 AM, Tony Weeg wrote:
> select sum(stopTime) from reports where vehicleNumberoni = 58444
>
> returns a null in sql server query analyzer.
>
> same query ran from cfmx, gives this error:
>
> [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow
> error converting _expression_ to data type int.
>
> 22001
>
> there are no values in that column for that vehicleNumberoni
> they are all null, however, why would cfmx choke, its just null?
>
> thanks!
>
> ...tony
>
> tony weeg
> senior web applications architect
> navtrak, inc.
> www.navtrak.net
> [EMAIL PROTECTED]
> 410.548.2337
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
