If statement test if xqueryresult.getString is empty

[agerber85]

Is there a good way to test in an if statement whether a xqueryresult.getString value is empty? I tried:
IF Result.getString(1) is not null THEN

But that went to to the else statement even when the string should have had contents. (I ran the mySQL query from the command line, just to make sure.)

Also tried:
IF not IsNull(Result.getString(1)) and not IsEmpty(Result.getString(1)) THEN

But that executed the if portion, even though I verified in the cmd line that IsNull(Result.getString(1)) should have been true.

[RobertG]

Use

IF Result.getString(1) <> "" THEN

String will be an empty string, not NULL. So you could only test the with Result.wasNull

[agerber85]

Thanks! You nailed it!