Would like to know what is the problem in my sql statement
"David G. Johnston" <[email protected]> Thu, 11 Jul 2019 19:34:24 -0700
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <CAKFQuwYGfEHWaC09vrhA7Wk4QO7ZESbHPxoVypaZnKRaA4LuvQ@mail.gmail.com> |
On Thursday, July 11, 2019, Karen Goh <[email protected]> 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.