Re: Pass column name in preparedstatement

In 7.3.3 is there any use in using PreparedStatement since the columns
may change for each query.

rgds
Antony Paul


On Wed, 16 Feb 2005 00:54:09 +1300, Oliver Jowett <oliver@opencloud.com> wrote:
> Antony Paul wrote:
> > Hi all,
> >     Is it possible to pass column name to a PreparedStatement as a
> > parameter.
>
> No, you can only use parameter placeholders in places which the backend
> grammar allows parameters (namely, in expressions). Column names aren't
> one of those places.
>
> > Or should I use Statement.
>
> You can use either Statement or PreparedStatement so long as you insert
> the column name into the SQL query string yourself before giving it to
> the driver.
>
> -O
>