Received: from flex.flex.ro (IDENT:root@[193.230.255.4]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA85101 for ; Wed, 21 Jul 1999 10:01:38 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.3/8.9.3) with ESMTP id RAA23495; Wed, 21 Jul 1999 17:01:42 +0300 Sender: teo@flex.flex.ro Message-ID: <3795D446.569D45E7@flex.ro> Date: Wed, 21 Jul 1999 17:08:06 +0300 From: Constantin Teodorescu Organization: FLEX Consulting X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.9 i586) X-Accept-Language: en MIME-Version: 1.0 To: Robson Martins CC: PostgreSQL Interfaces Subject: Re: [INTERFACES] ResultSet.... References: <000701bed37c$3fe796a0$1ed4d2c8@Designer2.netalfa.com.br> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit First of all : PLEASE, FIND A GOOD JAVA BOOK AND LEARN JAVA AND JDBC! Also, download JDBC documentation from Sun and read it! You will find all the information you need and even some examples. This list is * NOT * intented to be used for Java (JDBC) training. > 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! Try total = rs.getInt(1); Best regards, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA