Subject: Setting RowSet from database
From: "Mathews, Silvy (HQP)" <Silvy.Mathews@xxxxxxxx>
Date: Tue, 14 Mar 2000 13:41:58 -0800
|
Folks:
How do I set the ROWSET element with some name as the data reads from the
database in the xml file.
An example from XSQL looks like this
<xsql:query rowset-element="SiteStructure" row-element="Category"
produces the output as follows:
<SiteStructure>
<Category num="1">
--------------------------
</Category>
</SiteStructure>
What is wrong with the following code?
<query connection="Try1" rowset-element="MAINITEMS" row-element="CountryNum"
>
SELECT * FROM cml.country
</query>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|