Subject | setNull doesn't work |
---|---|
Author | Claudio D'Angelo |
Post date | 2002-07-26T18:22:27Z |
Hi,
I've a problem with interbase or interclient.
I've wrote this source
...
String select = "select * from xsysapps where DETRANSFER = ?";
PreparedStatement ps = this.con.prepareStatement(select);
ps.setNull(1, Types.DATE);
ResultSet rs = ps.executeQuery();
int i = 0;
while(rs.next())
i++;
System.out.println(i);
...
where all rows have DETRANSFER column to null.
The output of i is 0
if i change the select in "select * from xsysapps where DETRANSFER is null"
The query propertly work
Help me
Claudio D'Angelo
Software Consultant
ObjectWay S.p.A.
Via G.A. Boltraffio 7
20159 Milano (MI)
http://www.objectway.it
[Non-text portions of this message have been removed]
I've a problem with interbase or interclient.
I've wrote this source
...
String select = "select * from xsysapps where DETRANSFER = ?";
PreparedStatement ps = this.con.prepareStatement(select);
ps.setNull(1, Types.DATE);
ResultSet rs = ps.executeQuery();
int i = 0;
while(rs.next())
i++;
System.out.println(i);
...
where all rows have DETRANSFER column to null.
The output of i is 0
if i change the select in "select * from xsysapps where DETRANSFER is null"
The query propertly work
Help me
Claudio D'Angelo
Software Consultant
ObjectWay S.p.A.
Via G.A. Boltraffio 7
20159 Milano (MI)
http://www.objectway.it
[Non-text portions of this message have been removed]