I want to pass null value to cda parameter and wants to get all results if no parameter is passed but when I give no parameter cda file give error on executing query is it possible see image below@
can we pass null or no parameters to cda file
Can you please send me the catalina logs to see what the error is?
Also, I do not know if you are doing this, but in your query you should evaluate what is the parameter length. Because, when its value is null is length is 0.
I resolved my problem thanks for your help
Retrieving data ...