[Phpmyadmin-devel] editing and NULL values

Marc Delisle marc at infomarc.info
Fri Jul 15 16:10:42 CEST 2011

Le 2011-07-15 10:00, Ammar Yasir a écrit :
> On Fri, Jul 15, 2011 at 7:26 PM, Marc Delisle <marc at infomarc.info> wrote:
>> Le 2011-07-14 15:39, Ammar Yasir a écrit :
>>>>> There was a small thing I noticed on the row edit feature.
>>>>> When the form is displayed for row edit and some field is null, the
>> 'Null'
>>>>> checkbox is checked. When we select some value it is unchecked. It
>> should be
>>>>> checked again if we select the value empty or null but it does not. If
>> we
>>>>> forget to check it back this will give an SQL error.
>>>>> Screenshot attached for the sakila db film table where
>>>>> original_language_id is null, and if I miss checking it back I'll get
>> an SQL
>>>>> error.
>>> Sorry, missed the screenshots in previous mail. They are on my blog:
>>> http://ammaryasirr.blogspot.com/
>> I think you'll need to include js/tbl_change.js. There are a few
>> functions in there that deal with these kind of verifications. Beware,
>> some functions are not jQueryfied.
>> I found this problem in the tbl_change.php (when you edit a row from the
> table browse window) page. That includes the tbl_change.js script.

I believed you meant when editing from zoom-search, sorry. But I tried
with browse then editing the sakila.film and I don't see a problem.

Emptying a value is not the same thing as marking it NULL, this is why
the checkbox is there. Please give me a more precise scenario to work
with, including the SQL error you get.

Marc Delisle

More information about the Developers mailing list