Curtis Scheer wrote:> I noticed this one by searching in the archives, as I am working with
some> "optional" parameters myself and noticed your solution. I just wanted to> make one improvement suggestion which
isinstead of checking whether
or not> a parameter has been used simply start your query like so> Query_base := 'SELECT * FROM my_table WHERE 1 =1;>
Ifyou do that then you can just add on any parameters you need or
not add> any at all. I think that seems to be a bit simpler than having a
has_param"> Boolean variable.
True, I think I was too focused on the "clean" output, your solution
wastes less cycles and is more readable...
Snipet updated,
Thanks,
--
MaXX