>> 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]