But I have only one paramter in query. I can't pass an array parameter.
Again, the number of parameter is unknown and for this I use the IN statement
in sql.
Thanks,
Pietro
> Try:
>
> String[] params = {"1", "2"};
>
> Hen
>
> On Mon, Aug 25, 2008 at 2:12 PM, Pietro Santurelli <[EMAIL PROTECTED]> wrote:
> > Hi all,
> > I'm using common DbUtils 1.1 to execute this query:
> > SELECT column1 FROM table WHERE id_table IN (?).
> >
> > Java fragment code is:
> > String params = "1,2";
> > String query = "SELECT column1 FROM table WHERE id_table IN (?)";
> > QueryRunner qRunner = new QueryRunner();
> > ArrayList<Store> stores =
> > (ArrayList<Incasso>)qRunner.query(connection,query, params, new
> > BeanListHandler(Store.class));
> >
> > The ArrayList obtained is populated only with stores with id = 1. In other
> > words, the stores with id = 2 aren't retrieved. The semicolon seems to be
> > the problem.
> > Is this a bug of common DbUtils?
> >
> > Thanks in advance,
> > Pietro
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
