From: | Sabio - PSQL <slopez_pg(at)ceroriesgo(dot)co(dot)cr> |
---|---|
To: | PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Possible Bug in PreparedStatement |
Date: | 2005-04-01 20:08:01 |
Message-ID: | 424DAA21.7040206@ceroriesgo.co.cr |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-01 21:06:38 | Re: Help understanding VACUUM info on 7.4.5 |
Previous Message | Sabio - PSQL | 2005-04-01 20:04:41 | Help with statement |