[Phpmyadmin-devel] zoom-search, editing and NULL values

[Ammar Yasir]

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.

> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> AppSumo Presents a FREE Video for the SourceForge Community by Eric
> Ries, the creator of the Lean Startup Methodology on "Lean Startup
> Secrets Revealed." This video shows you how to validate your ideas,
> optimize your ideas and identify your business strategy.
> http://p.sf.net/sfu/appsumosfdev2dev
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110715/6401c120/attachment.html>