Not using a parameter is non was supplied

hq4ever

Hello,<br />
<br />
I have a query such as <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>select * from users where userId in (?)</pre>
<br />
The user can supply a parameter called "requestedSubscribers" I would like to have the where clause ignored if the user did not supply the parameter.<br />
<br />
I'm using Oracle 10.3 is that matters.<br />
<br />
<br />
Thank you for you support,<br />
Maxim.

mwilliams

Hi Maxim,

In the beforeOpen of your dataSet, you could check the parameter for null. If nothing was selected for it, you could set the query text with:

this.queryText = "select * from users";

Hope this helps.