On 20 Oct 2001 22:34:05 -0000, you wrote:
>PreparedStatement st = db.prepareStatement("UPDATE foo SET ? = '?' " +
> "WHERE number = ?");
>Whenever I use this I get a "Parameter index out of range" error.
>I am assuming that what this means is that I can't use a ? as a column
>name, but it can only be used as a parameter. Am I correct in this?
You can only use ? parameters to supply values, not table names,
column names or syntactical elements of SQL.
>Should I basically do it like this:
>PreparedStatement st = db.prepareStatement("UPDATE foo SET " + colname
> + "= '?' WHERE number = ?");
>Is that the only way to do this?
Yes. I don't think you need the single quotes though.
René Pijlman <rene(at)lab(dot)applinet(dot)nl>
In response to
pgsql-jdbc by date
|Next:||From: Rene Pijlman||Date: 2001-10-21 12:06:21|
|Subject: Re: Does PG's JDBC support prepared statements at all?|
|Previous:||From: Gunnar Rønning||Date: 2001-10-21 03:24:33|
|Subject: Re: [PATCHES] Ant configuration|