PreparedStatement vs. Statement problem

Поиск
Список
Период
Сортировка
От yoursoft
Тема PreparedStatement vs. Statement problem
Дата
Msg-id 474E5E18.4080909@freemail.hu
обсуждение исходный текст
Ответ на ssl connection and webstart  ("Michael Andreasen" <michael@dunlops.com>)
Ответы Re: PreparedStatement vs. Statement problem  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
I have a problem:
SELECT * FROM mytable WHERE c1 like 'a' UNION ALL SELECT * FROM mytable
WHERE c2 like 'a' || '%' AND c2 not like 'a' UNION ALL SELECT * FROM
mytable WHERE c2 like '%' || 'a' || '%' AND c2 not like 'a' || '%' AND
c2 not like 'a' LIMIT 101 OFFSET 0

Where 'a' is a variable.
When I run this query from Statement. There is no problem. The result is
ordered by: First SELECT, second SELECT third SELECT.
When I run this query from PreparedStatement ('a' values replaced by ?).
The result is ordered by in alphabets.Why?

Regards,
    Ferenc


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

Предыдущее
От: "Michael Andreasen"
Дата:
Сообщение: ssl connection and webstart
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: PreparedStatement vs. Statement problem