I am using a checkbox Pulldown and using
I am using "MyValue" to pass the selected values in the checkbox Pulldown to MYSQL query as an OR condition.
ex: select * from abc wherer name = 'xyz' OR $MyValue$
but the problem is, if no value is selected in the checkbox Pulldown nothing is being passed by $MyValue$ and the query looks as shown below and is not able to execute
ex: select * from abc wherer name = 'xyz' OR
You can pull up the "OR " part into the "outerTemplate" param like so:
<param name="outerTemplate">OR ($value$)</param>
and then when there are no terms to output and $MyValue$ dissappears, the OR will disappear with it.
You can pull up the "OR " part into the "outerTemplate" param like so:
<param name="outerTemplate">OR ($value$)</param>
and then when there are no terms to output and $MyValue$ dissappears, the OR will disappear with it.
Thank you so much for the fast reply it worked for me....