by Sorry, I know you've probably answer this one before, but I have my
.xml document and .xsl and I still can't get this to the web. The
table is Customers and the fields are ContactTitle and Country
(Northwind database). I'm using SQL Server 2000.
Here is my .xml document
<?xml version="1.0"?>
<customers xmlns:sql="urn:schemas-microsoft-com:xml-sql"
sql:xsl="customers.xsl">
<sql:query>
SELECT Country, ContactTitle FROM Customers for XML auto, elements
</sql:query>
</customers>
I have my .xsl
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:template match="/">
<HTML>
<Title>
DeliveryCo Web site
</Title>
<body bgproperties="fixed" bgcolor="lightsteelblue">
<H1>Customers Web Site</H1>
<p><font face="Arial" size="4">Outstanding Customers</font></p>
<TABLE border="0" width="100%" bordercolor="#009900">
<TR STYLE="font-size:12pt; font-family:Verdana;
font-weight:bold; text-decoration:underline">
<TD>Reference</TD>
<TD>Delivery Address</TD>
</TR>
<xsl:for-each select="Customers/Customer">
<TR >
<TD>
<xsl:value-of select="Country"/>
</TD>
<TD>
<xsl:value-of select="ContactTitle"/>
</TD>
</TR>
</xsl:for-each>
</TABLE>
</body>
</HTML>
</xsl:template>
</xsl:stylesheet>