Re: [INTERFACES] ResultSet....

On Wed, 21 Jul 1999, Robson Martins wrote:

> Hello all, i want to make a select count(*) and set a variable with this value i''m using the command:
>    rs = st.executeQuery("select count(*) from imoveis where imo_situ = 'venda' and imo_tipo = 'kiti'");
>    total = rs;
> But this doesnt work!
> How do i do what i want?
> I use Postgresql 6.5 and everything is working right (database connection), i only want to know how do i do this!
> Help me..
> Hugs...Robson
> 



Hi there




total = rs.getInt("count");


Leonel Nunez