Erik,
I'm afraid we can have more than one stored procedures. The reason is - I can have as many "Select" queries in the stored procedures as number of dropdown controls on the page. This stored procedure is executed only once before loading the page and get all the support table data to be filled in all dropdowns on the page. For performance reason, it is not practically possible to have more than one stored procedures executed for a page.
I would prefer this functionality supported by engine. Please help.
Thanks and Regards,
Rahul Agarwal
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
----------------------------------------------------------------------------------------
| Erik Bruchez <ebruchez @orbeon.com> Sent by: orbeon-user-admin 12/13/2004 05:15 PM
|
To: [EMAIL PROTECTED] cc: Subject: Re: [orbeon-user] Accessing Multiple Result Sets from SQL Server |
Rahul,
Right now the SQL processor is not able to access more than one result
set returned by a single query. It would have to be modified to
support Statement.execute() to do so.
Can you call two different procedures?
-Erik
> Hi,
>
> I'm using SQL processor for retrieving multiple result sets from a SQL
> server. I've a stored procedure in SQL server which has more than one
> "Select" queries and hence returning multiple result sets. Each result
> set essentially has two columns but column names are different in each
> result set.
>
> My questions are -
>
> 1. If I give following command, it shows rows from first result set
> only. What should I do to see rows of all result sets.
> <sql:results>
> <sql:row-results>
> <sql:get-columns format="xml"/>
> </sql:row-results>
> </sql:results>
>
> 2. How can I get output of multiple result sets in the format given
> below -
> <XMLData>
> <Name_of_first_column_of_first_result_set>
> <code>
>
value_of_first_column_of_first_result_set
> </code>
> <description>
>
> value_of_second_column_of_first_result_set
> </description>
> </Name_of_first_column_of_first_result_set>
>
> <Name_of_first_column_of_second_result_set>
> <code>
>
> value_of_first_column_of_second_result_set
> </code>
> <description>
>
> value_of_second_column_of_second_result_set
> </description>
> </Name_of_first_column_of_second_result_set>
> ....
> ....
> </XMLData>
>
> Thanks and Regards,
> Rahul Agarwal
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
orbeon-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/orbeon-user
