I have a dataassist update details page linked to a MySql database. The database has all of the columns set as default NULL. But when a user updates their details and still leaves one of the NULL fields blank it it changes it from NULL to NOT NULL, but just with no information.
Is there a way to set a field as NULL if there is no data entered in the update form?? I'm assuming it's all hand coding, but maybe there is an easy string I can type in the update field?
The only reason I'm using it is one of my SQL queries is based on whether a field is NULL.