[Phpmyadmin-devel] Inline edit and UPDATE feedback
rsedwardian at gmail.com
Sat Mar 19 22:03:27 CET 2011
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>
> >> 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
> >>>> 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
> >>> 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
> > 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
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Developers