You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by "Mathews, Silvy (HQP)" <Si...@rhii.com> on 2000/03/14 22:41:58 UTC

Setting RowSet from database

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>