Hai Javaid

      There are so many ways to count the records. One thing is just pass
the resultset object into a Vector and u can find the count or just move the
control to last record using resultset.last and u can get the row no using
resultset.getRow method. But I never try these. Just try and if it works
please confirm it.

Cheers

----- Original Message -----
From: "Javaid" <javaid@a...>
To: "Pro_JavaServer_Pages" <pro_jsp@p...>
Sent: Monday, October 23, 2000 12:36 AM
Subject: [pro_jsp] Record Counting in JSP


>
> Hello friends,
>
> I'm migrating from ASP to JSP, can any one tell me how to count no of
> records in a recordset, like ASP we do this by,
>
>
> strSql = "Select * from table"
>
> rs.open strsql
>
> mCnt = rs.RecordCount()
>
> How we count the nno of records in JSP.????
>
> javaid