james@dades.ca wrote:
> System.out.println("Error: ticket number not found
> in bol: so#="+sonumber+" ticket#="+token+";
> navroutno="+pRs.getString(2));
You probably don't meant to use pRs.getString() here. That's the
resultset that you already iterated through completely in the previous
loop (and the connection it was generated from is closed, anyway)
-O