Displaying total records

[Han Thai]

Hello,

Does anyone know if there is a function in Java to count the total records
in a resultset? I would like to display the total records retrieved from
a query before the table of results. Please help. Many thanks in advance.

Han

[Kent]

Han,

There is no method in the ResultSet interface to do this. Instead, just use
another query beforehand:

select count(*) as record_count from table_name

Regards,
Kent


"Han Thai" <hthaifr@hotmail.com> wrote:
>
>Hello,
>
>Does anyone know if there is a function in Java to count the total records
>in a resultset? I would like to display the total records retrieved from
>a query before the table of results. Please help. Many thanks in advance.
>
>Han
>

[Han Thai]

Thanks, Kent.

Regards,
Han


"Kent" <kb@essential.com.au> wrote:
>
>Han,
>
>There is no method in the ResultSet interface to do this. Instead, just
use
>another query beforehand:
>
>select count(*) as record_count from table_name
>
>Regards,
>Kent
>
>
>"Han Thai" <hthaifr@hotmail.com> wrote:
>>
>>Hello,
>>
>>Does anyone know if there is a function in Java to count the total records
>>in a resultset? I would like to display the total records retrieved from
>>a query before the table of results. Please help. Many thanks in advance.
>>
>>Han
>>
>