From: Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
To: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Possible Bug in PreparedStatement
Date: Fri, 01 Apr 2005 14:08:01 -0600
Message-ID: <424DAA21.7040206@ceroriesgo.co.cr> (raw)
Please do not respond last email, only this...
public int cedula_actualizar(String strcedula, String strids) {
PreparedStatement ST = null;
int retVal = 0;
try {
ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula=? WHERE consecutivo_identificacion IN (?)");
ST.setString(1, strcedula);
ST.setString(2, strids);
retVal = ST.executeUpdate();
ST.close();
} catch (Exception e) {
System.out.println(e.getMessage());
}
return retVal;
}
When execute this function with single data like this 3434 in strids, it
works, but when is pass somethine like this: 12232,3434,3,4545,34,3
don't work, Why?
In database cedula is varchar and consecutivo_identificacion is int
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: slopez_pg@ceroriesgo.co.cr
Subject: Re: Possible Bug in PreparedStatement
In-Reply-To: <424DAA21.7040206@ceroriesgo.co.cr>
References: <424DAA21.7040206@ceroriesgo.co.cr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox