I want to update a mysql db with a form. So I am using the form connector to update the table.
I have some fields in my table that have NULL as standard. But if I update it with the form, the connector will always insert a “0” where I have no entry.
I tried to make a beforeUpdate function like this:
if ($action->get_value('plz') == "" OR $action->get_value('plz') == 0) $action->set_value('plz', NULL);
but it still doesn’t update with NULL.
Does anybody know how to handle this?