Hi,
Apologies if this is a lame-brained question, but how does one enter a NULL when editing a record through XF?
My field is defined in MySQL as an INT and it can be made NULL; default is also NULL; but when I go to edit the field in XF's Edit mode, I cannot find a way to make that field blank: it always becomes a zero (0). This happens if I remove the field's contents, put in a space, escape or backslash a space or nothing, or put in "".
Since we're working with data where a 0 is a score (while NULL is not), we need that NULL.
I've now reset this field to VARCHAR, which allows XF to set the field to nothing, but that loses me some of the advantages of INT.
Any help most appreciated.
