Setting RowSet from database

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


Current Thread