Re: PreparedStatement: setting column names dynamically

Chantal,

You probably want to do something like a persistence layer, look at
castor, not sure of the url, but google castor persistence should give
you something.

Dave
On Fri, 2002-07-26 at 07:25, Chantal Ackermann wrote:
> hello all,
> 
> sorry, if this has already been asked:
> 
> Is it possible to set column or table names in a PreparedStatement 
> similar to setting values? I happen to do this very often and in a very 
> structured way. If it would be possible I could reuse the prepared 
> statement.
> 
> what I mean is:
> 
> at the moment I have a query like:
> 
> "Select " + column + " from " + table + " where " + column + "=?";
> 
> and I would like to have something like:
> 
> "Select ? from ? where ?=?";
> 
> I see that PreparedStatement doesn't provide any setColumn() methods or 
> whatever. but there might be some other way I am not aware off, I hope!
> 
> Any ideas, suggestions, tips?
> Thank you
> Chantal
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 
>