if you use rs.next() and the result set is null, you will probably need to use a do while instead of just a while for the loop... never had a problem myself though, maybe if we had some more info on your specific problem.
Thats what I was doing but the weirdest thing, the recordSet would not return all the records that met the criteria,
I mean I execute the query then check it with rs.next() and oracle would just return some of the records not all, not to mention the fact that if there is data it skips the first record, which I don't want.
So I reckon Rudy has the right Idea beforeFirst().
I'm using a while(rs.next()) and writing the data to an ArrayList to get the number of values that way and it works perfectly.
Thats what I meant by unreliable.
[ November 10, 2004: Message edited by: Reggie McDougal ] [ November 10, 2004: Message edited by: Reggie McDougal ]