Re: ANY subquery and PreparedStatements

Поиск
Список
Период
Сортировка
От Jason S. Friedman
Тема Re: ANY subquery and PreparedStatements
Дата
Msg-id 20030219145721.GA3142@charles
обсуждение исходный текст
Ответ на Re: ANY subquery and PreparedStatements  (Felipe Schnack <felipes@ritterdosreis.br>)
Ответы Re: ANY subquery and PreparedStatements
Список pgsql-jdbc
My two cents:  it would be great if Java had a built-in (JDK) method that did the same thing as the Perl join command:

@array = ( 'apple', 'banana', 'orange' );
$fruit = join( ',', @array );
# result is 'apple,banana,orange'

On Wed, Feb 19, 2003 at 09:56:47AM -0300, Felipe Schnack wrote:
>   Yes, this would work... but it's not very pretty :-)
>   JDBC's preparedstatements should have *some way* to handle that...
> simply makeing impossible to use such an useful keyword is quite bad...
>   Or jdbc doesnt have it?
>
> On Wed, 2003-02-19 at 09:49, Pavel Fokin wrote:
> > Felipe Schnack wrote:
> >
> > >  I'm afraid it kind of impossible to use PreparedStatements with the
> > >"ANY" subquery keyword... For example, if I take this query and prepare
> > >it:
> > >  "select * from <table> where <field> any (?)"
> > >  How can I set my parameter as a list of values, so my query searches
> > >for for different values of the specified field?

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: pg73jdbc3.jar ClassNotFoundException
Следующее
От: Felipe Schnack
Дата:
Сообщение: Re: ANY subquery and PreparedStatements