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.
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.
3 Answers:
Posted on August 21, 2006 at 5:08pm
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
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
