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
