Hi Rahul,
Just a guess, but try this:
<sql:results>
<rows>
<sql:row-results>
<sql:row-results>
<row>
<sql:get-columns format="xml"/>
<sql:get-columns format="xml"/>
</row>
</sql:row-results>
</sql:row-results>
</rows>
</sql:results>
</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.
----------------------------------------------------------------------------------------
"Matthew J. Graham" <mjg
@cacr.caltech.edu>
Sent by: orbeon-user-admin12/10/2004 04:06 AM
Please respond to orbeon-user
To: [EMAIL PROTECTED]
cc:
Subject: [orbeon-user] Dynamic generation of xforms
Hi,
A busy day on the list!
I am trying to dynamically generate the XForm instance using a pipeline:
<page id="standardresults" path-info="/query/standardresults"
xforms="query/results-xforms-model.xml"
view="query/results-standard-view.xsl">
<action when="/form/action = ''">
<result page="sampleclient"/>
</action>
</page>
<page id="sampleclient" path-info="/sampleclient"
xforms="query/sampleclient-xforms-model.xpl"
view="query/sampleclient-view.xsl">
</page>
where query/sampleclient-xforms-model.xpl builds the:
<xforms:model>
<xforms:instance>
...
</xforms:instance>
<xforms:submission method="post"/>
</xforms:model>
based on the instance document from the standardresults page - it makes
a query against the database. The instance document is of the form:
<form>
<title/>
<endpoint/>
<param name=""/>
</form>
where title and endpoint have values and there can be a variable number
of param elements. The problem I have is that it is not get passed to
the view properly. If I specifiy the output of the pipeline as:
<p:param type="output" name="data"/> then the instance document seen by
the view is just:
<form>
<title/>
<endpoint/>
</form>
where title and endpoint are empty. However, if I use:
<p:param type="output" name="instance"/>
then I get an exception:
Type class org.orbeon.oxf.common.ValidationException
Message Root element of XForms model must be in namespace
http://www.w3.org/2002/xforms
Location
Line N/A
Column N/A
Stack Trace
Class Name Method Name File Name Line Number
org.orbeon.oxf.processor.xforms.Model$1 startElement Model.java 69
in spite of the namespace of root element model being defined and
qualified as xforms.
Am I doing this the right way?
Cheers,
Matthew
-------------------------------------------------------
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
