Paul McNeil wrote:
Thank you very much for the response. According to MySQL Control Center the
MySQL DB I am connecting to is version 4.0.17. Possibly that is the
problem.
You'll get quicker (and, on average, better) responses if you keep the
thread on the list.
I have mysql 4.0.17 running on a
Paul McNeil wrote:
Good morning to all.
I have a problem with a workaround but I wanted to know if others have run
into this.
Are you sure the problem is with mysql? If so, which version do you have?
I have 4.0.20, and I get different (expected) results.
Table DATA
Column strength [double]
CREAT
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.get
>> 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 Maili
Good morning to all.
I have a problem with a workaround but I wanted to know if others have run
into this.
Table DATA
Column strength [double]
When I select strength from DATA and the result is a non zero amount it
returns correctly
3.256498
however if it is a 0 amount I get
0.
The p
