Mulitple values in a Parameter List

[rachele51]

In comparison to the SQL statement :: IN (nn, nn, nn)

I need to do the same thing with a $P{nn, nn, nn)

 

how do I accomplish this in IReports when I'm propted for a input.

[ripolking]

Hi,

 

I have the same problem.

 

I tried many ways to do this with no success.

 

Ronald.

[maili]

Hi,

 

I have the same problem - have either of you found a solution yet?

 

Thanks

[teodord]

Hi,

 

You would have to use the $P!{paramName} syntax, because in this case you are actually modifying the query and those are not normal PreparedStatement parameter place-holders.

 

SELECT * FROM table WHERE column IN {nn, nn, nn}

 

would become

 

SELECT * FROM table WHERE column IN {$P!{paramName}}

 

where

 

paramName=nn, nn, nn

 

 

I hope this helps.

Teodor