Le 2011-07-15 10:15, Ammar Yasir a écrit :
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/
Ok I had played to much with my version of sakila and was missing some relations. I recreated it. The real problem is that the list of values should not contain a blank value. Now I'm wondering in which situation we need this blank line! This comes from libraries/relation.lib.php in PMA_foreignDropdown(). Checking NULL automatically is not something phpMyAdmin can decide to do. However we know we can uncheck it when a value has been entered. -- Marc Delisle http://infomarc.info