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