I'm using a FOR-EACH like:
----
<xsl:for-each select="ROOT/Level1/Level2">
-----
Then building a table by defining columns:
------
<table>
<tr>
<td><xsl:value-of select="ProdID"><td>
<td><xsl:value-of select="ProdName"><td>
<td><xsl:value-of select="ProdType"><td>
</tr>
</table>
--------
but, I want to hyperlink one of the columns to use an http:// sql query
-----
<a
href="http://munsql01/DCR?SQL=SELECT+*+FROM+DailyView+where+prodDate+=+'5/23/2003'+for+xml+auto,elements&xsl=Prodview.xsl&root=ROOT">
<xsl:value-of select="ProdID">
</a>
------
but need to add a variable in the query that uses the current row's ProdID.
Basically somehow add 'and ProdID=<xsl:value-of select="ProdID">'
Into that query.
This leaves me with 2 questions:
1. How do I have more control over the value-of in a for-each per row? When
I attempt to test using a variable it always pulls the first row's value and
not the row that it is currently in. Is there a way to reference the current
row's value and not the first one in the list?
2. Once I have established a way to use the current row's value-of, how
would I pass that into the hyperlinked query as an argument, adding the
where ProdID=currentrow ProdID?
Any help is most appreciated as this seems to be a general naviagation issue
and would seem common, I cannot find reference to this anywhere after
extensive searching. I basically need to reference the current rows value
instead of the first in the list.
Thank you,
Brian Lewandowski
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list