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
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?