Would like to know what is the problem in my sql statement

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Would like to know what is the problem in my sql statement
Дата
Msg-id CAKFQuwYGfEHWaC09vrhA7Wk4QO7ZESbHPxoVypaZnKRaA4LuvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Would like to know what is the problem in my sql statement  (Karen Goh <karenworld@yahoo.com>)
Ответы Re: Would like to know what is the problem in my sql statement  (Karen Goh <karenworld@yahoo.com>)
Список pgsql-sql
On Thursday, July 11, 2019, Karen Goh <karenworld@yahoo.com> wrote:

Please tell me why it says no value specified for parameter 1.

HashMap<Integer, ArrayList<String>> tutorSubject = new HashMap<Integer, ArrayList<String>>();

String sql1 = "select tutor_id, subject_name from tutor_subject where subject_name in ("
                                                       + builder.deleteCharAt( builder.length() -1 ).toString() + ")";                           


Because you don’t have any parameter placeholder symbols in your query?  I.e., the question mark “?” character...

David J.

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

Предыдущее
От: "Juan C. Olivares"
Дата:
Сообщение: Re: Would like to know what is the problem in my sql statement
Следующее
От: Karen Goh
Дата:
Сообщение: Re: Would like to know what is the problem in my sql statement