From: Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>
To: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Help with statement
Date: Fri, 01 Apr 2005 14:04:41 -0600
Message-ID: <424DA959.3060004@ceroriesgo.co.cr> (raw)
public int cedula_actualizar(String strcedula, String strids) {
PreparedStatement ST = null;
int retVal = 0;
try {
ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula='"+strcedula+"' WHERE consecutivo_identificacion IN ("+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: Help with statement
In-Reply-To: <424DA959.3060004@ceroriesgo.co.cr>
References: <424DA959.3060004@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