Consider a query such as: dslContext.select(aField).from(someTable).where(nameField.eq(name)); where name is a String. This translates to this parameterized query: select aField from someTable where nameField = ?;
How do you achieve the same type of parameterization with an in-list such as: dslContext.select(aField).from(someTable).where(nameField.in(names)); where names is a List of Strings. I expect this to translate to: select aField from someTable where nameField in (?, ?, .... ?) where there are as many '?' as there are names. Is there a way to achieve this? If not, what is the alternative to guard against SQL injections? -- 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.
