[Phpmyadmin-devel] zoom-search and editing

[Ammar Yasir]

On Wed, Jul 13, 2011 at 3:24 AM, Ammar Yasir <ayax88 at gmail.com> wrote:

>
>
> On Tue, Jul 12, 2011 at 6:32 PM, Marc Delisle <marc at infomarc.info> wrote:
>
>> Le 2011-07-11 21:26, Ammar Yasir a écrit :
>> >
>> >
>> > On Mon, Jul 11, 2011 at 3:16 AM, Marc Delisle <marc at infomarc.info
>> > <mailto:marc at infomarc.info>> wrote:
>> >
>> >     Le 2011-07-09 22:59, Ammar Yasir a écrit :
>> >      >
>> >      >
>> >      > I've done a basic version of edit functionality. I added a unique
>> >      > identifier for each row in the query result data by using the
>> >      > PMA_getUniqueCondition() from the common.lib.php file
>> >     (where_clause). I
>> >      > then generate the update query in the edit submit event using
>> >     this where
>> >      > clause and post it to sql.php. The return data is added to the
>> >      > <sqlqueryresult> div to show the query executed and the message.
>> The
>> >      > plot also updates on submit if one of the axes is updated. Is my
>> >     logic
>> >      > is okay?
>> >      > I've pushed my work and you can try scenarios on the film_actor
>> >     table in
>> >      > the sakila database.
>> >
>> >     Ammar,
>> >     I tried with the film table, changing the "title" column and got
>> >     this error:
>> >     value is undefined at line 177 in js/tbl_zoom_plot.js.
>> >
>> > Fixed some issues and pushed it to my repo. Had to add checkboxes for
>> > null condition on fields (in Data point content section).
>>
>> It works fine now.
>> Please don't forget the issue of generating the default data label based
>> on the "display field".
>>
>
Fixed this, default label is taken from table display field.
Also changed the type of xAxis to linear (t defaulted to timeline earlier).

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.

>
>> Yes, working on it now.
>
>> --
>> Marc Delisle
>> http://infomarc.info
>>
>>
>> ------------------------------------------------------------------------------
>> All of the data generated in your IT infrastructure is seriously valuable.
>> Why? It contains a definitive record of application performance, security
>> threats, fraudulent activity, and more. Splunk takes this data and makes
>> sense of it. IT sense. And common sense.
>> http://p.sf.net/sfu/splunk-d2d-c2
>> _______________________________________________
>> Phpmyadmin-devel mailing list
>> Phpmyadmin-devel at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>
>
>
>
> ------------------------------------------------------------------------------
> 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/7f1822ba/attachment.html>