Hi! friend!
Try using "getFetchSize();" of the resultset CLass
sanjeev
At 05:55 PM 8/23/00 +0530, you wrote:
>U can try using the getUpdateCount() method in java.sql.Statement....
>----- Original Message -----
>From: Naveen Gupta <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, August 23, 2000 5:17 PM
>Subject: Re: JDBC: want to know the no of record fetch my any select query
>
>
>> Amar try this
>>
>> ResultSet rs=stmt.executeQuery("select count(*) from tablename");
>> rs.next();
>> int x=rs.getInt(1);
>> out.println(x);
>>
>> Now this x will show thw no of records
>>
>> or u can use
>>
>> ResultSet rs=stmt.executeQuery("select * from tablename");
>> int x=0;
>> while(rs.next()){
>> x++;
>> }
>> out.println(x);
>>
>> This will also show the no of records
>>
>>
>>
>> -----Original Message-----
>> From: amar singhal [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, August 23, 2000 5:09 AM
>> To: [EMAIL PROTECTED]
>> Subject: JDBC: want to know the no of record fetch my any select query
>>
>>
>> Hi,
>> I am using jdbc 1.1 driver. I want to know the records fetch by any
>> select
>> query statment.
>>
>> thanks.
>> Amar Singhal
>>
>>
>> ________________________________________________________________________
>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>> ========================================================================
>> ===
>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>> JSP-INTEREST".
>> Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>>
>>
>===========================================================================
>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>> Some relevant FAQs on JSP/Servlets can be found at:
>>
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>>
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
Sanjeev Kumar Sharma
Velocient Technologies Ltd.
F-2/B-1, Mohan Co-operative Industrial Estate,
New Delhi-110044.
Off:- # 91-6945226/7/8-120
Res:- # 91-4518858
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
