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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Karen Goh <karenworld(at)yahoo(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Would like to know what is the problem in my sql statement
Date: 2019-07-12 02:34:24
Message-ID: CAKFQuwYGfEHWaC09vrhA7Wk4QO7ZESbHPxoVypaZnKRaA4LuvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karen Goh 2019-07-12 12:22:57 Re: Would like to know what is the problem in my sql statement
Previous Message Juan C. Olivares 2019-07-12 02:11:27 Re: Would like to know what is the problem in my sql statement