RE: Select double value

[Victor Pendleton]

Are you catching the error? Are you sure the value returned is what you  are
expecting? 

-----Original Message-----
From: Dean Urmson
To: 'Paul McNeil'; mysql@stripped
Sent: 6/7/04 8:16 AM
Subject: RE: Select double value

>> The problem is that in my java.sql.ResultSet.getDouble("strength")
>> a zero amount throws a number format exception.

Hi Paul,

Not a Java user so I haven't tested this.

You could try...

SELECT abs( strength ) FROM data ;

It 'might' stop the exception!

Cheers

Dean


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1