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.