ResultSet object

L. Riley

Greenhorn

Posts: 28

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

How do I retrieve the number of records in a ResultSet?

Bosun Bello

Ranch Hand

Posts: 1514

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You can do a select count(*) on the querry you plan to execute, or if your are usung JDBC 2.0 you can move to the last row in your resultset using yourresultsetobject.last() and then get your record count based fo the row number.
You may want to do a search in the JDBC forum. It has been discussed there several times.
------------------
Bosun
SCJP for the Java� 2 Platform

Bosun (SCJP, SCWCD).
So much trouble in the world -- Bob Marley

Matthew Phillips

Ranch Hand

Posts: 2676

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This is more appropriate for the JDBC forum. I will move it there for you.
Matthew Phillips

Matthew Phillips

A sonic boom would certainly ruin a giant souffle. But this tiny ad would protect it:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing