JDBC and NaN in where condition
Posted on 2000-03-27
I try to retrieve rows that include columns with an NaN value as Float.
I use preparedStatement.
ex : select c1,c2,c3 where c1 = ?
java code is like :
ps = con.preparedStatement(select c1,c2,c3 where c1 = ?);
rs = ps.executeQuery();
I know that some rows match this case, but rs.next() return false
Can somebody help me ?