| 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: | Whole Thread | Raw Message | 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 |