I'm getting an error message that I have exhausted my resultset, how do I get around this? I'm trying to first search for an applicant by ssn, then display the applicant's info which is no problem but then I want to be able to go to a new page to edit the applicant's data and I get error 'exhausted result set'? Can anyone help?
Tracy, My guess is that you've got a reference to a forward-only ResultSet (ResultSets can be acquired in many different flavors) and you've "exhausted" the ResultSet by scrolling to the end of the thing using your normal, iterative construct:
I'm now assuming you have a reference to that same ResultSet object on your next page and you're either trying to iterate to the record for updating purposes or, attempting to modify a record although your cursor has reached the end of the ResultSet. Just something to look at...but I'm fairly sure you're attempting to scroll through a ResultSet that you've already burned through.