Hi, i have the following asp file that connects to a database, extracts records and generates xml data - I wish to format this data on the fly, so I tried this:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="xmlstyle.xsl"?>
<DATA>
... connect to database here and extract records....
<%for i=1 to 10%>
<Record>
<Number><%=theNumber
(i)%></
Number>
<Date><%=theDate(i)%
></Date
>
</Record>
<%Next%>
</DATA>
the xmlstyle.xsl is as follows:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="
http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<table>
<xsl:for-each select="DATA/Record">
<tr>
<td><xsl:value-of select="Number" /></td>
<td><xsl:value-of select="Date" /></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
What I end up with is this:
<?xml version="1.0" encoding="ISO-8859-1"?> <?xml-stylesheet type="text/xsl" href="xmlstyle.xsl"?> <DATA> <Record> <Number>100</Number> <Date>Dec-2008</Date> </Record> <Record> <Number>300</Number> <Date>Jan-2008</Date> </Record> <Record> <Number>500</Number> <Date>Dec-2008</Date> </Record> <Record> <Number>1000</Number> <Date>Feb-2008</Date> </Record> <Record> <Number>566</Number> <Date>Mar-2008</Date> </Record> <Record> <Number>566</Number> <Date>Apr-2008</Date> </Record> <Record> <Number>244</Number> <Date>Apr-2008</Date> </Record> <Record> <Number>12</Number> <Date>May-2008</Date> </Record> <Record> <Number>600</Number> <Date>Dec-2008</Date> </Record> <Record> <Number>100</Number> <Date>Aug-2008</Date> </Record> </DATA>
there is no formatting of the XML. When I copy this into a new page and run it in a browser it shows the correct formatting - what do I need to do to have the xml render correctly? Thanks
Start Free Trial
