Try

	int count = (rs.getInt(1);

-----Ursprungliche Nachricht-----
Von: BIPIN MEHTA [mailto:bsm3477@y...]
Gesendet: Freitag, 30. Marz 2001 07:59
An: Pro_JavaServer_Pages
Betreff: [pro_jsp] Resultset problem



 hi all,

  I have the following situation,

  ResultSet rs = stmt.executeQuery("select count(*)
from tableA");

  how do i put the count into a int variable after
this ?

 thanks in advance.

 regards,
 
 Bipin Mehta.
  

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text