Re: Count items in reslutset?



Donkey Hot wrote:

ResultSet rs ;
int count ;

....

count = rs.getInt(1) ;

One should probably add that this row count cannot be used to determine the number of rows of a subsequent SELECT statement that selects actual row data (not just the count) from the same table. Between the two SELECT statements the number of rows may have changed.

--
-----------------------------------------------------------------------
Dr. Uwe Seimet http://www.linkbylink.net/
.