Hi there,
What is the recommended way for providing a variable list of parameters to a
jasper report xml file for use in an sql in clause?
ie select * from table where id in ($P{list})?
For Mysql I used to be able to use a string variable which I created by
concatenating all the values i.e "1,3,5,75" etc when we switched to using
DB2 this didn't work anymore and I am getting number format exception
(NumberFormatException). Should I pass the value in as an array of Integers?
thanks
Mark
--
View this message in context:
http://www.nabble.com/How-to-stipulte-list-of-values-for-%22in%22-clause-in-a-sql-query-using-parameters--tf3503839.html#a9785524
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
