Oliver Jowett wrote:
> james(at)dades(dot)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)
Thank you, Oliver. That was indeed my problem.
James