Delete Dates?

QuestionsDelete Dates?
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

5 Answers
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,

Pete answered 11 years ago

Just tried to buy it, but your payment link doesn't work!

Abu Ghufran answered 11 years ago

I've emailed you direct link and paypal alternate link.
Apologies for inconvenience.

Your Answer

13 + 9 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?