[Phpmyadmin-devel] Display multiple query results at once

Hi Michal, I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page. But, in order to get those multiple query results, from where I should execute those two queries separately ? If it is SQL tab in pma, is it a task relating to above title that improving SQL query window page to adding multiple query boxes ? or any suggested way ? Regards ! [1] http://wiki.phpmyadmin.net/pma/GSoC_2012_Ideas_List#Refactoring:_Displaying_... -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

Hi Chanaka, On 27/03/12 22:08, Chanaka Dharmarathna wrote:
Hi Michal,
I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page.
Yes, this is correct, the results will be appear as set of tables in the same page.
But, in order to get those multiple query results, from where I should execute those two queries separately ?
This issue has to do with displaying multiple result sets produced by a stored procedure. And it's somewhat related to this bug[0]. I've added an extra note about this on the wiki. Hope this helps, but feel free to ask for further clarification :) Bye, Rouslan [0]: https://sourceforge.net/tracker/?func=detail&aid=3474853&group_id=23067&atid...

On Wed, Mar 28, 2012 at 2:57 AM, Rouslan Placella <rouslan@placella.com>wrote:
Hi Chanaka,
On 27/03/12 22:08, Chanaka Dharmarathna wrote:
Hi Michal,
I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page.
Yes, this is correct, the results will be appear as set of tables in the same page.
But, in order to get those multiple query results, from where I should execute those two queries separately ?
This issue has to do with displaying multiple result sets produced by a stored procedure. And it's somewhat related to this bug[0]. I've added an extra note about this on the wiki.
Hope this helps, but feel free to ask for further clarification :)
Bye, Rouslan
[0]: https://sourceforge.net/tracker/?func=detail&aid=3474853&group_id=23067&atid...
------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Rouslan, Thank for your quick reply. I got the idea what you meant by going through the bug you send me. I have a look into that. Thank you for pointing out that. Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

Hi Dne Wed, 28 Mar 2012 02:38:09 +0530 Chanaka Dharmarathna <pe.chanaka.ck@gmail.com> napsal(a):
I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page.
But, in order to get those multiple query results, from where I should execute those two queries separately ?
If it is SQL tab in pma, is it a task relating to above title that improving SQL query window page to adding multiple query boxes ? or any suggested way ?
There is not need to add multiple query boxes as you can enter multiple queries in one (eg. SELECT 1; SELECT 2). Anyway this is mostly important for routines as described earlier by Rouslan. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

On Thu, Apr 5, 2012 at 7:08 PM, Michal Čihař <michal@cihar.com> wrote:
Hi
Dne Wed, 28 Mar 2012 02:38:09 +0530 Chanaka Dharmarathna <pe.chanaka.ck@gmail.com> napsal(a):
I feel it's better to have some clarifications on above title under [1] in GSoC idea list. This topic is mentioned about displaying multiple query results at once in same page (Please make me correct if I'm wrong). The results will be appear as set of tables in the same page.
But, in order to get those multiple query results, from where I should execute those two queries separately ?
If it is SQL tab in pma, is it a task relating to above title that improving SQL query window page to adding multiple query boxes ? or any suggested way ?
There is not need to add multiple query boxes as you can enter multiple queries in one (eg. SELECT 1; SELECT 2). Anyway this is mostly important for routines as described earlier by Rouslan.
-- Michal Čihař | http://cihar.com | http://blog.cihar.com
------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Michal, I got the idea you mentioned and already have started to fix the bug [0] using multiple queries in the same SQL query box. [0]: https://sourceforge.net/tracker/?func=detail&aid=3474853&group_id=23067&atid... Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya Sri Lanka ____________________________________
participants (3)
-
Chanaka Dharmarathna
-
Michal Čihař
-
Rouslan Placella