Daniel Israel
05-14-2007, 06:47 PM
Hello,
I'm working on a stylesheet that displays a subscription database with expiration dates.
The stylesheet looks like this:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE xsl:stylesheet>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="/">
<table><TR><TH>Name</TH><TH>Date Activated</TH><TH>Expiration Date</TH></TR>
<xsl:for-each select="Subscribers/Subscriber">
<TR>
<TD><xsl:value-of select="Name"/></TD>
<TD><xsl:value-of select="DateActivated"/></TD>
<TD><xsl:value-of select="Expiration"/></TD>
</TR>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
A sample of the data looks like this:
<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="subscribers.xslt"?>
<Subscribers>
<Subscriber>
<ID>1</ID>
<Name>Holmes, Sherlock</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:04:44 AM</DateActivated>
<Expiration>12/31/2020</Expiration>
<AccountType>N</AccountType>
<Status>Active</Status>
</Subscriber>
<Subscriber>
<ID>2</ID>
<Name>Jagger, Mick</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:06:21 AM</DateActivated>
<Expiration>12/31/2020</Expiration>
<AccountType>N</AccountType>
<Status>Active</Status>
</Subscriber>
<Subscriber>
<ID>3</ID>
<Name>Dillinger, John</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:16:53 AM</DateActivated>
<Expiration>12/31/2005</Expiration>
<AccountType>N</AccountType>
<Status>Expired</Status>
</Subscriber>
</Subscribers>
This works great with one exception... When I have a Name with an odd character in it, it bombs. By odd character, I mean something that you don't have in the normal American character set (accents, umlaut, etc...). I'm sure I'm just missing some small thing, but I'm still sort of a novice at this yet. Can someone kick me in the right direction?
Thanks.
I'm working on a stylesheet that displays a subscription database with expiration dates.
The stylesheet looks like this:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE xsl:stylesheet>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="/">
<table><TR><TH>Name</TH><TH>Date Activated</TH><TH>Expiration Date</TH></TR>
<xsl:for-each select="Subscribers/Subscriber">
<TR>
<TD><xsl:value-of select="Name"/></TD>
<TD><xsl:value-of select="DateActivated"/></TD>
<TD><xsl:value-of select="Expiration"/></TD>
</TR>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
A sample of the data looks like this:
<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="subscribers.xslt"?>
<Subscribers>
<Subscriber>
<ID>1</ID>
<Name>Holmes, Sherlock</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:04:44 AM</DateActivated>
<Expiration>12/31/2020</Expiration>
<AccountType>N</AccountType>
<Status>Active</Status>
</Subscriber>
<Subscriber>
<ID>2</ID>
<Name>Jagger, Mick</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:06:21 AM</DateActivated>
<Expiration>12/31/2020</Expiration>
<AccountType>N</AccountType>
<Status>Active</Status>
</Subscriber>
<Subscriber>
<ID>3</ID>
<Name>Dillinger, John</Name>
<Email>xxxx@xxx.com</Email>
<DateActivated>1/23/2004 8:16:53 AM</DateActivated>
<Expiration>12/31/2005</Expiration>
<AccountType>N</AccountType>
<Status>Expired</Status>
</Subscriber>
</Subscribers>
This works great with one exception... When I have a Name with an odd character in it, it bombs. By odd character, I mean something that you don't have in the normal American character set (accents, umlaut, etc...). I'm sure I'm just missing some small thing, but I'm still sort of a novice at this yet. Can someone kick me in the right direction?
Thanks.