Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ResultSet....

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-interfaces by date

Next:From: Hugh LawsonDate: 1999-07-21 12:27:48
Subject: Re: [INTERFACES] [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL
Previous:From: Eric MarsdenDate: 1999-07-21 10:35:56
Subject: [ANN] pg.el v0.2 -- Emacs Lisp interface to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group