background shape
background shape

NULL value comparison in IF statement

If you have field in DE that its value is not always populated for a particular row (customer) and you test field value against any value cloud page will throw an 500 – internal server error.

%%[
var @field;// null value


if @field == 4 then
//500 
endif

]%%

To fix this, you will simply need to add another AND-condition to test field value for NULL with NOT IsNull()

%%[
var @field;// null value


if NOT IsNull(@field) AND @field == 4 then
//do something
endif

]%%

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

Share With Others

Leave a Comment

Your email address will not be published. Required fields are marked *

MarTech consultant

Marcel Szimonisz

Marcel Szimonisz

I specialize in solving problems, automating processes, and driving innovation through major marketing automation platforms.

Buy me a coffee