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