Pete asked 11 years ago
I need to to be able to delete a date from a date field. Whenever I try to delete the date from a field it doesn't delete, just leaves the date that was already set in place.
My database is set to allow NULL in these fields, and I've tried using the $col["isnull"] = true; parameter but still no joy.
Any help would be appreciated.
Pete
Abu Ghufran answered 11 years ago
Most likely the UPDATE sql is causing error.
You can recheck it using firebug, and see the response of update ajax call.
https://phpgrid.desk.com/customer/portal/articles/926266
Pete answered 11 years ago
The error showing is:
Couldn't execute query. Incorrect date value: '' for column 'DateSetFor' at row 1 – UPDATE tbldetentions SET Reason='HMK',Faculty='MATH',Staff='PIW',DateSetFor='',DateServed='',SMTDetSet='',Action='' WHERE DetentionID = '12'
Would appear the '' is not NULL so database is rejecting it. Even with the "isnull" parameter set.
Any help muchly appreciated, thanks.
Pete
Abu Ghufran answered 11 years ago
Hello,
The "isnull" is introduced in 1.4.8, and most likely you are using free version which is little outdated.
Perhaps, you have to wait till i release new update of free version.
Or, if you have plans to buy license, you can get latest build.
Regards,
Abu Ghufran answered 11 years ago
I've emailed you direct link and paypal alternate link.
Apologies for inconvenience.
