Vaishali,
In this code you are closing the while for rs1 after the while of rs2 only.
So after reading the first record u r forcing to go to second resultset.
Correct code is as a follows:
while (rs1.next()){
;
;
}
;
rs2.executeQuery(cmd);
while(rs2.next()){
;
;
}
Regds
Cukku
> -----Original Message-----
> From: Vaishali S. Pandya [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 1:36 PM
> To: [EMAIL PROTECTED]
> Subject: resultset in resultset not working
>
> hi friends
>
> here 2 resultsets rs1 and rs2
>
> while (rs1.next()){
> ;
> ;
> rs2.executeQuery(cmd);
> while(rs2.next()){
> ;
> ;
> }
> ;
> ;
> }
>
> there are some records in rs1 but after executing 1st record it comes out
> from while.
> rs2 is working fine.
> where I mistep?
> can anyone make me correct?
>
> Thanks
> Vaishali
> Reliance Ind Ltd
> A'bad
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
