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.