var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conditional evaluation in where clause
I use this expression in my where clause
if I set <value> to NULL the condition is skipped
((isnull(<value>)) or (colname = <value>))
If I set the <value> to some real value it is evaluated
i am in need of something similar for the IN statement, in that case <value> becomes <values list> but then
if <values list> is null the condition is skipped otherwise i get an error because
((isnull(<values list>)) or (colname in <values list>))
isnull((2,3,4)) is not accepted by mysql
any suggestion to make this work?
I think if you use the COALESCE function in your ISNULL statement, you may get what you are looking for.