Re: PreparedStatement: setting column names dynamically

hello Dave,

thank you for the link. it looks very interesting though I haven't found
a straight solution to my problem yet. but I might solve some of my
other problems using it. ;-)

cheers
Chantal

Dave Cramer wrote:

>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
>>
>>