I would try using array of longs instead of a string. On Sun, May 28, 2017 at 11:16 AM, <[email protected]> wrote:
> Hi, > > I would like to write a simple select statement using the IN operator. > [select * from X where id1 = 21 and id2 in (1,2) ] > > I tried the following: > > create.select().from(view).where(whereClause, whereBindings); > > > whereClause = id1 = ? and id2 in ? > > > whereBindings[0] = 21L > > whereBinding[1] = "(1,2)" > > > Which resulted with: > > select * > from X > where (id1 = 21 and id2 in '(1,2)') > > > What is the proper way to write such a query? > > > Thanks! > > Liran > > > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
