Passing a dataset Parameter to a Query for IN

sweaver

<p>Hi Guys,</p>
<p> </p>
<p>Is there a way to pass a parameter to a query for the following - and if so, how?</p>
<pre class="_prettyXprint">
SELECT *
FROM TABLE
WHERE TABLE.CAPTION IN ?</pre>
<p>To be something like<span style="color:rgb(0,0,0);font-size:13px;background-color:rgb(250,250,250);">SELECT * </span></p>
<pre class="_prettyXprint _lang-sql">
FROM TABLE
WHERE TABLE.CAPTION IN ('abc','def')
</pre>
<p>My current attempts have been rather unsuccessful and I can't figure out what to search for.</p>
<p> </p>
<p>Many thanks</p>

shir

<p>Hi,</p>
<p> </p>
<p>As far as i understand there is no ready made utility available for multiple parameter select statements.</p>
<p> </p>
<p>Below is a link which discusses the same issue and a possible solution for the same.</p>
<p> </p>
<p><a data-ipb='nomediaparse' href='http://birtworld.blogspot.in/2009/03/birt-multi-select-statements.html'>http://birtworld.blogspot.in/2009/03/birt-multi-select-statements.html</a></p&gt;
<p> </p>
<p>I have not tried it out myself, however the comments to the blog suggest that it does.</p>
<p> </p>
<p>Thanks</p>