Are you catching the error? Are you sure the value returned is what you are
expecting?
-----Original Message-----
From: Dean Urmson
To: 'Paul McNeil'; [EMAIL PROTECTED]
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
