I have a select (drop down) field configured where users select a name and the respective employee id is written to the mySQL database field. The database field is set an integer data type.
During normal record editing if I set that field blank the database entry write a Null.
However, if I select ” – Empty – ” during bulk editing it’ll try and set those fields to “” instead of Null, resulting in a incorrect integer SQL error.
Is there a way to ensure the ” – Empty – ” option writes Null values instead of “” for this column? I’ve tried the isnull column parameter but that doesn’t appear to make a difference.
I’ve emailed you latest build. It should make ‘isnull’ property work as expected.
Abu Ghufran - Dev Team
PHP Grid Framework
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!