Parameter in a "in" statement

[mathiasen_jakob]

Hello, Please tell me how to pass a parameter to an sql-sentence like this:

select * from t_Table where ID in $P{parameter1}

Thanks

Jakob

[deloreanguy]

The IN operator requires a parenthetical notation, such as WHERE D IN (A, B, C)...

I haven't tried using parms with an IN clause, but put parends around it first...

[Giulio Toffoli]

the syntax is:

 

select ... where $X{IN, colname, paramname}

paramname is a parameter of type Collection or array. If null or empty, the condition is replaced by 0=0.

Giulio

[tdi120]

If you are not using a collection or list, like Giulio suggested, then the syntax would be:

 

select col1,col2 from table1 where col1 IN ( $P!(parameter1) )

Notice the spaces, notice the "!"

The "!" mark, tells that the value should be passed raw into the sql query

That only works with strings, because you cannot pass a list of integers, properly formatted for the query.

So unless you are manually introducing the parameters as:

1,2,56,78,99

you will have to use a collection, which takes me to the answer Giulio already provided.

Hope that helps

 

Alexandru Ersenie

[mathiasen_jakob]

Thanks a lot.. Just what I needed !!