On Thursday, July 11, 2019, Karen Goh <karenworld(at)yahoo(dot)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.