Re: Total No. of records

[Chris Pratt]

There are various frameworks available that can hide the gory details from you, but there are basically two ways using JDBC.   Get the ResultSet and iterate through it counting as you go Use a database specific feature such as Oracle's COUNT operator.  i.e. "SELECT COUNT(*) FROM EMPLOYEES WHERE COUNTRY='US'"     (*Chris*) ----- Original Message ----- From: Gautam Batra To: [EMAIL PROTECTED] Sent: Friday, August 06, 1999 4:20 AM Subject: Total No. of records Hi all !   How can I know the total number of records retrieved from the database MS Access. I am also using JRun 2.3 and IIS 4.0   Thankx in advance  !   Gautam