Received: from unimur.um.es (unimur.um.es [155.54.1.1])
	by hub.org (8.10.1/8.10.1) with ESMTP id e6CBDoW54709
	for <pgsql-interfaces@postgresql.org>;
	Wed, 12 Jul 2000 07:13:51 -0400 (EDT)
Received: from aries.dif.um.es (aries.dif.um.es [155.54.210.253])
	by unimur.um.es (8.9.1b+Sun/8.9.1) with ESMTP id NAA23071
	for <pgsql-interfaces@postgresql.org>;
	Wed, 12 Jul 2000 13:13:47 +0200 (MET DST)
Received: from dif.um.es (labredes15.dif.um.es [155.54.210.9])
	by aries.dif.um.es (Postfix) with ESMTP id 426C6EC1A
	for <pgsql-interfaces@postgresql.org>;
	Wed, 12 Jul 2000 13:13:39 +0200 (MET DST)
Message-ID: <396C52DF.BBE06E9C@dif.um.es>
Date: Wed, 12 Jul 2000 13:13:35 +0200
From: Gabriel =?iso-8859-1?Q?L=F3pez=20Mill=E1n?= <gabilm@dif.um.es>
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: DELETING ROW
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from base64 to 8bit by hub.org id e6CBDqW54713
X-Archive-Number: 200007/73


    Hi all.

    I'm traying to delete a row of a table. Te code is:

 String query = "DELETE FROM " + ID_REQUEST_TABLE + " WHERE id = '" +
numReq+ "';";
 int result = s.executeUpdate(query);
 System.out.println("result: " + result);
 if(result != 0) {
     .....
     connection.commit();
  }


    If file do not exists "result" should be "0" (JDBC API), if exists,
it should be the number of the row that delete. But I always get the
value "1", always, even if the row to delete is 5,6, ... 10.

    I'm using postgresql 7.02 with linux RedHat 6.0 and jdk1.2

    Cheers, Gabi.