I just upgraded from 2.0.1 to 2.3.current and am rewriting a stylesheet to use 
the new sql extension. When I write:

<xsl:variable name="streets1" select="sql:query($db, $query)"/>
<xsl:for-each select="$streets1/sql/row-set/row">
       <xsl:value-of select="col[2]"/>
</xsl:for-each>

Only the last row of the query is output.

To get all the rows I've found I need to nest the for-each:

<xsl:for-each select="$streets1/sql/row-set">
    <xsl:for-each select="row">
       <xsl:value-of select="col[2]"/>
    </xsl:for-each>
</xsl:for-each>

This doesn't seem right. Is it maybe a bug? I'm using JDK1.3.1 and the 
sun.jdbc.odbc.JdbcOdbcDriver.



Reply via email to