This content has been marked as final. Show 5 replies
You need to loop through your data and remove null values then populate.
Exactly. It's showing null, because you have a null value in your database. If you don't want that to show you could set the default in the fields of the database to ' ' or do like Mush said and remove the null values in code.
I am aware that there is null data in the database. I already examined the XML generated, If the field is null, and I do not nvl it, the xml does not contain the field at all. If I nvl it to a space the xml contains "<FieldName />."
I certainly have no idea how to "Loop through the data," nor what to do in the loop when the data element would not exist. If I wanted to loop through data, I'd still be writing assembler:->
Is there no way to define the default action to return a "" for data that is null or does not exist, or is there an equivalent to nvl/coalesce?
This appears to have no rational solution that I could find.
However I found a VERY kludgy way of handling the problem. For every field that might contain a null do the following;
((data.VENDOR_CONTACT == null)?'':data.VENDOR_CONTACT)
BTW I tried ".toString()", but when concatenating to a field with a null the resulting string appears to be null.
I sure hope that someone has a better answer than the above mess.
Try something like this
Array 1 raw list
for each value in array 1 as s
If s == Null
seed a new array with value
news = s