From: | PostgreSQL <postgres(at)sys(dot)com(dot)mx> |
---|---|
To: | Robson Martins <robson(at)netalfa(dot)com(dot)br> |
Cc: | pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] ResultSet.... |
Date: | 1999-07-21 10:57:41 |
Message-ID: | Pine.LNX.4.10.9907210655570.23336-100000@gonzo.sys.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hugh Lawson | 1999-07-21 12:27:48 | Re: [INTERFACES] [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL |
Previous Message | Eric Marsden | 1999-07-21 10:35:56 | [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL |