Re: Count items in re****set?

WJ <wjz@[EMAIL PROTECTED]
> wrote in news:e1c38$4810c8fc$3ec2c5b8$6409
@[EMAIL PROTECTED]
> Hi all,
> 
> Is it possible to get the number of rows in a resultset using SQL?
> 
> If I execute a statement like: SELECT COUNT(*) FROM table1 WHERE ID=12,
> 
> I dont know how to assign the result to an integer...
> 
> Thanx,
> WJ
> 

ResultSet rs ;
int count ;

.....

count = rs.getInt(1) ;