-----Original Message-----
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: 10 May 2004 14:11
To: CF-Talk
Subject: RE: does cf choke on database nulls?
You need to alias it,
Select sum(stoptime) as stoptime from reports....
jb
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 10 May 2004 14:13
To: CF-Talk
Subject: does cf choke on database nulls?
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]