New subject: [Phpmyadmin-devel] zoom-search and redirection

21 Jul 2011

On Fri, Jul 15, 2011 at 7:26 PM, Ammar Yasir &lt;ammaryasir.88(a)gmail.com&gt;wrote;wrote:

...

 On Fri, Jul 15, 2011 at 7:19 PM, Marc Delisle &lt;marc(a)infomarc.info&gt; wrote:

  Le 2011-07-14 15:39, Ammar Yasir a écrit :
  On Fri, Jul 15, 2011 at 1:01 AM, Ammar Yasir
&lt;ammaryasir.88(a)gmail.com
wrote:

 On Fri, Jul 15, 2011 at 12:59 AM, Ammar Yasir &lt;ammaryasir.88(a)gmail.com wrote:
>
>>
>>
>> On Wed, Jul 13, 2011 at 3:24 AM, Ammar Yasir &lt;ayax88(a)gmail.com&gt; 
wrote:
  >
>>
>>
>> On Tue, Jul 12, 2011 at 6:32 PM, Marc Delisle &lt;marc(a)infomarc.info
wrote:
>>>
>>>> Le 2011-07-11 21:26, Ammar Yasir a écrit :
>>>>>
>>>>>
>>>>> On Mon, Jul 11, 2011 at 3:16 AM, Marc Delisle &lt;marc(a)infomarc.info
>>>>> <mailto:marc@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. 
 It still does not work. When I initially enter Zoom search, $zoom_submit
 and $inputs are not defined so $dataLabel does not receive the results
 of PMA_getDisplayField($db,$table).

 I think I misunderstood. What I am doing is that, if a user does not  selects a
datalabel, it defaults to the display field. That works fine. I
 guess what you are saying is that the default selected value/index should be
 the 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/
>
> 
Hi,
I missed out on one more issue to be fixed, if we refresh the zoom-search
page at any stage it just shows two panels with table names and blank page
on the right frame. I wanted a refresh to take us back to the tbl_search
page, like we have clicked the search tab on the maintabs. I have almost the
same code as tbl_select page, $goto is taken from '$goto =
$GLOBALS['cfg']['DefaultTabTable']' , why is it going wrong?

...
  --
  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(a)lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Re: [Phpmyadmin-devel] zoom-search and redirection