Skip to main content
Question

Running SQLExecutor with blank Parameters

  • May 28, 2018
  • 1 reply
  • 4 views

Hi,

I have an SQLExecutor that uses some Public Parameters in the WHERE condition. If the user leaves the Parameter blank then the query look for blank "" fields. How can I dynamically control what goes into the WHERE condition, so when the parameter is blank we exclude that condition?

Thanks

1 reply

david_r
Celebrity
  • May 28, 2018

The easiest solution may be to test for a blank where-statement and replace it with something like

WHERE 1=1

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings