Received: from paris.netalfa.com.br ([200.210.212.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA75877
	for <pgsql-interfaces@postgresql.org>;
	Wed, 21 Jul 1999 09:26:37 -0400 (EDT)
	(envelope-from robson@netalfa.com.br)
Received: from Designer2 ([200.210.212.30])
	by paris.netalfa.com.br (8.9.2/8.9.2) with SMTP id KAA20901
	for <pgsql-interfaces@postgresql.org>;
	Wed, 21 Jul 1999 10:29:30 -0300 (EST)
Message-ID: <000701bed37c$3fe796a0$1ed4d2c8@Designer2.netalfa.com.br>
Reply-To: "Robson Martins" <robson@netalfa.com.br>
From: "Robson Martins" <robson@netalfa.com.br>
To: "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
Subject: ResultSet....
Date: Wed, 21 Jul 1999 10:23:40 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0004_01BED363.1A2C81A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01BED363.1A2C81A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello all, i want to make a select count(*) and set a variable with this =
value i''m using the command:
   rs =3D st.executeQuery("select count(*) from imoveis where imo_situ =
=3D 'venda' and imo_tipo =3D 'kiti'");
   total =3D 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

------=_NextPart_000_0004_01BED363.1A2C81A0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hello all, i want to make a select count(*) and set =
a variable=20
with this value i''m using the command:</FONT></DIV>
<DIV><FONT size=3D2>&nbsp;&nbsp; rs =3D st.executeQuery("select count(*) =
from=20
imoveis where imo_situ =3D 'venda' and imo_tipo =3D =
'kiti'");<BR>&nbsp;&nbsp; total=20
=3D rs;</FONT></DIV>
<DIV><FONT size=3D2>But this doesnt work!</FONT></DIV>
<DIV><FONT size=3D2>How do i do what i want?</FONT></DIV>
<DIV><FONT size=3D2>I use Postgresql 6.5 and everything is working right =
(database=20
connection), i only want to know how do i do this!</FONT></DIV>
<DIV><FONT size=3D2>Help me..</FONT></DIV>
<DIV><FONT size=3D2>Hugs...Robson</FONT></DIV></BODY></HTML>

------=_NextPart_000_0004_01BED363.1A2C81A0--