AnsweredAssumed Answered

Best way to deal with ExecuteSQL empty return values?

Question asked by bigtom on May 1, 2016
Latest reply on May 1, 2016 by user19752

When I have a I have a query like:

"SELECT a, b, c, d FROM Table WHERE IDpk = ?"; "¶"; ""; $id)

 

This gives me a return delimited list of the selection. I want this list to work with GetValue predictably but when one or more of the return values is empty it causes a problem. What is the best way to deal with this? Replacing "" with a known value for an empty field is not really an option in this case.

Outcomes