> On Fri, Jul 15, 2011 at 7:40 PM, Marc Delisle <
marc@infomarc.info> wrote:
>
>> Le 2011-07-15 10:00, Ammar Yasir a écrit :
>>> On Fri, Jul 15, 2011 at 7:26 PM, Marc Delisle <
marc@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.
>>
>>
>> If i try the film table in sakila database, and edit any row. The
> original_language_id is null initally and if I select andy value the check
> is unchecked. Then again if I select ' ' in the select box, I though it
> should turn the check back on, just in case if I forget it gives an error.
>
> The screen shots are on my blog
http://ammaryasirr.blogspot.com/