Hi folks… I have an infuriating problem which I should have been able to fix but haven’t been able to.
I am querying a mySQL database. The database has some missing data in a date field (field called dateAdded). I need to pick this up in a function so I can either format the date if it exists or ignore it if it doesn’t.
The problem is that no function is picking up that the field is empty even though it says “empty” when i examine the history. I have tried all combinations of null, emptystring, “”,isempty… etc.
I set up a simple test scenario that replicates the issue. Basically one module runs the SQL query and the other other then populates a variable so we can examine the variable to see what’s what. The variable comes back as empty so as to test it further, I populated the variable with length(dateAdded) and it came back with 12.
My supposed empty variable has a length of 12??? Screenshots below.
What on earth am I doing wrong?
Result from Query:
Set Variable Length()
Set Variable Length result
Original Value in mySQL table