[Phpmyadmin-devel] zoom-search and editing

[Ammar Yasir]

On Fri, Jul 15, 2011 at 1:01 AM, Ammar Yasir <ammaryasir.88 at gmail.com>wrote:

>
>
> On Fri, Jul 15, 2011 at 12:59 AM, Ammar Yasir <ammaryasir.88 at gmail.com>wrote:
>
>>
>>
>> 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.
>>
>
Sorry, missed the screenshots in previous mail. They are on my blog:
http://ammaryasirr.blogspot.com/

>
>
>>
>>>> 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/c45b6bf8/attachment.html>