pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





Message-ID: <424DAA21.7040206@ceroriesgo.co.cr>
Permalink:  ../424DAA21.7040206@ceroriesgo.co.cr/
Also on:    postgresql.org/message-id/424DAA21.7040206@ceroriesgo.co.cr

 · 

reply

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