<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output indent="no" method="html"/>
<xsl:template match="/PXSQL/DBI">
<html>
<head>
  <title>Customers list</title>
</head>
<body bgcolor="#FFFFFF">
<h2>Customers list</h2>

<table border="1">
<tr><th>Id</th><th>Name</th><th>Givenname</th><th>Age</th></tr>
<xsl:for-each select="CUSTOMER/ROW">
<tr>
<td>
<xsl:value-of select="id"/>
</td>
<td>
<xsl:element name="a">
<xsl:attribute name="href">/cgi-bin/PXSQL/examples/perl_xsql.pl?template=person1&amp;id=<xsl:value-of select="id"/></xsl:attribute>
<xsl:value-of select="name"/>
</xsl:element>
</td>
<td>
<xsl:value-of select="givenname"/>
</td>
<td>
<xsl:element name="a">
<xsl:attribute name="href">/cgi-bin/PXSQL/examples/perl_xsql.pl?template=person2&amp;age=<xsl:value-of select="age"/></xsl:attribute>
<xsl:value-of select="age"/>
</xsl:element>
</td>
</tr>
</xsl:for-each>
</table>
<p>
<xsl:element name="a">
<xsl:attribute name="href">/cgi-bin/PXSQL/examples/perl_xsql.pl?template=article</xsl:attribute>
View items
</xsl:element>
</p>
</body>
</html>

</xsl:template>
</xsl:stylesheet>
