DMXzone Database Updater 2 Support Product Page

INSERT NULL IN A DATABASE FIELD

Asked 17 Dec 2019 13:41:08
1
has this question
17 Dec 2019 13:41:08 EDUARDO PEREZ posted:
Hi, I need insert null value in field database when I delete all text in a field form. How could I do that? Thanks in advanced.

Replies

Replied 18 Dec 2019 08:25:45
18 Dec 2019 08:25:45 Teodor Kuduschiev replied:
Hello Eduardo,
Why not set null as a default value for your database field?
Replied 18 Dec 2019 08:35:08
18 Dec 2019 08:35:08 EDUARDO PEREZ replied:
I did it in mysql database. I have a field called observations in the database. Sometimes I need this field contain info and sometimes not. I would like to set null value in the field database through an update form, not only empty the field.
Replied 07 Jan 2020 12:11:48
07 Jan 2020 12:11:48 Teodor Kuduschiev replied:
In the update record step try using:
 {{$_POST.your_input.default(null)}}

Reply to this topic