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