Encoding danske karakterer
Hej,Jeg har et stykke XML, som jeg sorter med XSL, således at der returneres det samme XML - bare sorteret.
VBScript:
Dim oXML,oXSL
On Error Resume Next
Set oXML = CreateObject("Msxml2.DOMDocument.4.0")
Set oXSL = CreateObject("Msxml2.DOMDocument.4.0")
oXML.async = False
oXSL.async = False
oXML.LoadXML o.toString()
oXSL.Load server.mapPath("xsl/pvXSL.xsl")
response.write oXML.transformNode(oXSL)
XML:
<?xml version="1.0" encoding="windows-1252" ?>
- <pageviews>
<tc>43</tc>
<c>43</c>
- <page>
<pagename>Velkommen</pagename>
<pvc>36</pvc>
<pagepro>83,72</pagepro>
<pageavg>83,72</pageavg>
</page>
- <page>
<pagename>Færdigvarer</pagename>
<pvc>3</pvc>
<pagepro>6,98</pagepro>
<pageavg>6,98</pageavg>
</page>
- <page>
<pagename>Om Wimex</pagename>
<pvc>1</pvc>
<pagepro>2,33</pagepro>
<pageavg>2,33</pageavg>
</page>
- <page>
<pagename>Historie</pagename>
<pvc>1</pvc>
<pagepro>2,33</pagepro>
<pageavg>2,33</pageavg>
</page>
- <page>
<pagename>Efterbehandling</pagename>
<pvc>2</pvc>
<pagepro>4,65</pagepro>
<pageavg>4,65</pageavg>
</page>
</pageviews>
XSL:
<?xml version='1.0'?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" encoding="windows-1252"/>
<xsl:template match='/'>
<pageviews>
<tc><xsl:value-of select='pageviews/tc'/></tc>
<c><xsl:value-of select='pageviews/c'/></c>
<xsl:for-each select='pageviews/page'>
<xsl:sort select='pvc' data-type='number' order='descending'/>
<page>
<pagename><xsl:value-of select='pagename'/></pagename>
<pvc><xsl:value-of select='pvc'/></pvc>
<pagepro><xsl:value-of select='pagepro'/></pagepro>
<pageavg><xsl:value-of select='pageavg'/></pageavg>
</page>
</xsl:for-each>
</pageviews>
</xsl:template>
</xsl:stylesheet>
Jeg har et problem med encodingen. Ved danske karakterer æøå kommer der en fejl:
An invalid character was found in text content. Error processing resource 'http://XXX/pageviewsXML.asp?ds=01-08-2002&de=06-09-2002'. Line 1, Position 174
Nogen der har styr på encoding??
Mvh
Martin