[Phpmyadmin-devel] Inline edit and UPDATE feedback

[rohit sharma]

On Sun, Mar 20, 2011 at 2:15 AM, Marc Delisle <marc at infomarc.info> wrote:

> Le 2011-03-19 16:42, rohit sharma a écrit :
> > On Sun, Mar 20, 2011 at 2:03 AM, Marc Delisle <marc at infomarc.info>
> wrote:
> >
> >> Le 2011-03-19 16:21, rohit sharma a écrit :
> >>> On Sun, Mar 20, 2011 at 1:45 AM, Marc Delisle <marc at infomarc.info>
> >> wrote:
> >>>
> >>>> Hi,
> >>>> by default, the ShowSQL directive is true, which makes the generated
> SQL
> >>>> appear on top for almost every action. This fulfills many needs:
> >>>> - people teaching SQL
> >>>> - user who wants to verify what phpMyAdmin did in the backend
> >>>>
> >>>> However with Inline edit, we no longer see this generated SQL and I'm
> >>>> wondering if something should be done about this.
> >>
> >>>
> >>> Hi,
> >>>
> >>> We can add a field for the last inline_edit query run by the user, and
> >>> display it using a show/hide button. This field can be added just
> beneath
> >>> the "generatedSQL" which is always displayed.
> >>
> >> Hi,
> >> in the case of Edit, there is no Show/hide because the interface
> >> respects the $cfg['ShowSQL'] directive, so why should there be a
> >> Show/hide in the case of Inline Edit?
> >
> > Hi,
> >
> > In case of Edit, the query tends to be small, "select * from table_name;
> "
> > (talking generally, although the query can be much longer) , and on the
> > other hand inline-edit queries are update queries which can be quite long
> > for tables with more columns, hence it would take away some valuable
> space
> > from the displayed table.
>
> I'm not sure I follow you. If you browse a table, click Edit on some row
> and make a change, you'll see the generated UPDATE statement, followed
> by a SELECT representing your current results set.
>
>
> --
> Marc Delisle
> http://infomarc.info
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>

Hi,

Thanks. I got the idea. But in the case of "inline_edit" the query is being
sent using Ajax, and the frame won't  move after a query execution, so where
do your propose to display the inline_edit query that was last run, so that
the user gets notified.

--
Regards

Rohit Sharma
CSE
IIIT-Hyderabad <http://iiit.net/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110320/93921c18/attachment.html>