I'm using a
BuildRowsetFromString function and while it shows the correct data when there are values, or if a record is not in the dataset, if a record appears with blank data I can't get anything to display.
Here's what I've tried:
%%[ SET @rowset = LookupOrderedRows("Recently-Browsed",1,"Add Date Desc","EmailAddress", EmailAddr) IF RowCount(@rowset) == 0 THEN SET @browsing = "Not Found" ELSE RowCount(@rowset) > 0 THEN SET @browsing = FIELD(ROW(@rowset, 1), "Product Categories Viewed - Top") ENDIF ]%% %%[ SET @CategoryRows = BuildRowsetFromString(@browsing,"|") FOR @i = 1 TO RowCount(@CategoryRows) DO SET @CategoryRow = Row(@CategoryRows,@i) SET @Category = Field(@CategoryRow,1) ]%% %%[NEXT @i]%%
%%[ IF @category == "" THEN SET @browsing = "Null Row" ELSE SET @browsing = @category ENDIF]%% %%=v(@browsing)=%%
null, it still shows a blank, and not "Null Row" as expected.
What am I missing here?