No Matt. It doesn't work. Actually the problem is to get multiple result sets and not multiple rows. By "result set" I mean output of one "Select" query which can have 'N' number of rows. When you have multiple result sets, then it shows rows from first result set only.
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.
----------------------------------------------------------------------------------------
| "Matt Allen" <matt.allen @riverdynamics.com> Sent by: orbeon-user-admin 12/11/2004 01:02 AM
|
To: <[EMAIL PROTECTED]> cc: Subject: RE: [orbeon-user] Accessing Multiple Result Sets from SQL Server |
Hi Rahul,
Just a guess, but try this:
<sql:results>
<rows>
<sql:row-results>
<row>
<sql:get-columns format="xml"/>
</row>
</sql:row-results>
</rows>
</sql:results>
Or something like that (can't remeber off the top of my head).
-Matt
Matt Allen
Client Services Director - 0413 777 771
River Dynamics
Winner, Outstanding Australian Product Innovation
- 2004 iAwards
Winner, Innovation In Claims Management
- 2003 Australasian Claims Expo
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rahul Agarwal
Sent: Friday, December 10, 2004 10:28 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [orbeon-user] Accessing Multiple Result Sets from SQL Server
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
----------------------------------------------------------------------------------------
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.
----------------------------------------------------------------------------------------
