[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Processing rowsets of multiple queries

Subject: Processing rowsets of multiple queries
From: Oleg Konovalov <olegkon@xxxxxxxxx>
Date: Thu, 10 Nov 2005 19:21:56 -0500
sql pick
Hi,

I am writing a browser popup displaying results of multiple queries,
sort of a DB report using Cocoon 2.0.4 [XSL 1.0]

I am receiving correct XML output from SQLTransformer
(see below).

Now need XSLT page to work.

It seems that correct form to pick up a rowset in XSL is:
<xsl:variable name='custdata'
select="/page/content/sql:rowset[@sql:name='query1']"/>,
should have rows/columns under that.

The query returns 1 row (that's OK).
But for whatever reason I can't get to the row, to show the
values on the screen:
<xsl:for-each select='$custdata'>  <-- expect to pass $custdata/row
  <xsl:call-template name='row1'>
    <xsl:with-param name='therow' select='.'/>x
  </xsl:call-template>
</xsl:for-each>

<xsl:template name="row1">
  <xsl:param name='therow'/>
<tr>
  <td>data=<xsl:value-of select='$therow'/></td> <--- can see the whole row
  <td align="left" valign="middle"><xsl:value-of
select='$therow/col1'/></td>                             <--- can't
see the column
</tr>
</xsl:template>

What am I doing wrong ?
(probably some silly XSL bug in my code :-(  )
Sorry for the newbie question.

Thank you,
Oleg.

<page>
  <content>

  <rowset nrofrows="1" name="query1">

    <row>
      <col1>Name1</col1>
      <col2>Property1</col2>
...
    </row>
   </rowset>

....  other rowsets
 </content>
</page>

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.