SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 12:38 AM
| ||||
| ||||
 Possible Bug in PreparedStatement 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
Linear Mode
