[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] xsl:for-each table with control over current row's value-of

---

---

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&amp;xsl=Prodview.xsl&amp;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

---