I need to test to see if a returned resultset is empty in order to trigger a message being displayed...how do i test for an empty resultset? (Need this ASAP if anyone can help!) Thanks!
Ok well rs.next() etc. actually moves the db cursor from its current position, so that why you are getting results off by 1. How about trying something like this instead then:
On top of spaghetti all covered in cheese, there was this tiny ad:
a bit of art, as a gift, that will fit in a stocking