Hi

Yeah IN is not supported.

Wonder what a good syntax for that would look like, as you would need
to differentiate the values should be enclosed in quotes or not, eg
strings vs numbers etc.

We have also previously talked about being able to specify the SQL
type to use for the parameters. So if we can come up with a good
syntax for that we can maybe add the IN stuff too.

That said there is other SQL components in camel that support this
like MyBatis, or potentially ElSql etc.



On Thu, Mar 3, 2016 at 1:38 PM, fabrizio.spataro
<fabrizio.spat...@bizmate.it> wrote:
> hello,
>
> i would execute this query:
>
> <to uri="sql://select * from dummy where id IN (:#idsList)?dataSource=mysql"
> />
>
> But i am thinking it is not supported yet.
>
> How to do it?
>
> Tnkx, fabrizio
>
>
>
> --
> View this message in context: 
> http://camel.465427.n5.nabble.com/camel-sql-Query-with-params-list-tp5778544.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2

Reply via email to