dynamic dataset parameter binding - possible?

badhorse

We have lot's of sql queries that take "in lists" ie: "where x in (a,b,c)", where the number of items in the list varies and is a String parameter to the report and where we dynamically construct the queryText with string concatenation. Apparently this is less efficient for the database than a prepared statement with a known number of bound parameters due to the parsing involved (this is what I'm told anyway).

Given that we can parse the report parameter to determine how many items are in the list, and given that we can dynamically change the queryText and replace the ("+params["list"]+") with the appropriate # of parameter placeholders (?,?,?), is it possible to dynamically prepare and bind the parameters to the query?

Thanks in advance.

J

badhorse

btw, nice related article by Scott at <a class='bbc_url' href='http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html'>BIRT World: BIRT Multi-Select Statements</a>. But it sadly doesn't quite address this.