Hello, I have a problem with the display of the content of my database.
I have some fields empty but when I see the list, some of those fields are blank and others contents “null”.
I don’t understand why and how to correct that.
Could you help me ?
Thanks.
Marc
1 Like
What’s the problem exactly?
Are you unable to change the text / data in the fields?
To change it, you just click on the field and change it.
No, I can change the content but actually, there is nothing in the fields (like 218 and 219) but sometime it displays nothing and sometime it displays “null” (like 220 and 221).
I don’t undertsand why…
What’s the problem???
Is it a problem that there is nothing?
If it’s a problem, why don’t you just add something??
No, the problem is that sometime I see nothing and sometime I see “null”…why ??? (see my printscreen in Série).
There is nothing in those fields but the display is different.
But is it ruining your site?
If you don’t like how it looks, why don’t you just change the text?
But I have no text to change, it MUST be empty and I don’t want to see “null” in place of nothing.
So just delete “null” ?
But I can’t !!!
That is my problem…in my databse, the field is empty but when I see the result on my published site, I see “null” sometime…
Ohhhh
I thought “null” was in thedatabase.
Hmm, weird.
A funny workaround would be to copy-paste an “empty character” into the field:
Hey there, I see the issue. I’ll try to explain the technicality as simply as possible:
In Wix CMS, when you add a new row, all the blank fields that you see are set to undefined.
What is undefined, you may ask? It is Javascript’s way of knowing that there is nothing here. Now Javascript has two similar keywords to describe “blank”. One of them is undefined and the second one is null.
What happens is if you click on a blank field inside the CMS database and do not add any data, it turns from undefined to null. And the only way to change the field value back to undefined is via code.
And if you do not have any experience in Velo, your only option (as far as my knowledge) would be to add a new in the CMS, fill in the data again, and remember not to click on the fields that are meant to be blank! (:
OK thank you for your help…it works…
In the article Empty character…from kreativhold, the second proposition is OK.
I generate an blank character, copy it in the clipboard and paste it in my database.
After synchronisation, the “null” are removed and I have a real blank.
I didn’t know the difference between undefined and null…never too late to learn… 
Many thanks…
Regards.
Marc
1 Like
Hey Marc,
Remember to mark the thread with a solution.
Happy that it worked out for you.
X
1 Like