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