String parameter

flosmi

<p>Hi,</p><p> </p><p>i want to insert a string parameter into my statement:</p><p> </p><p>select id from test</p><p>where id in (?)</p><p> </p><p>the parameter are e.g.: 'A12','A14'</p><p> </p><p>but i think birt creates something like:</p><p>...</p><p>where id in(''A12','A14'')</p><p> </p><p>how can i prevent the outer ' ' when i use string parameter?</p><p> </p><p>thanks</p>

micajblock

<p>First of all your SQL is not valid SQL. You cannot parameterize an IN clause like that. If you are using a multi-select parameter, you can use this technique:</p><p> </p><p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause</a></p&gt;