RE: [xsl] Carriage return in XML

Subject: RE: [xsl] Carriage return in XML
From: "Matthew Day" <mday@xxxxxxxxx>
Date: Thu, 10 Feb 2005 12:28:50 +1300

Actually the problem seems to be the encoding not the CR at all.

In a hex editor I see a ~ at the start of their XML file but not mine.
However when I change my xml template to <?xml version="1.0"
encoding="UTF-16"?> from <?xml version="1.0" encoding="UTF-"8"?> the process
now produces an empty file. Any idea why this may be?

This is the template.

<?xml version="1.0" encoding="UTF-16"?>
<CSM xmlns:sql="urn:schemas-microsoft-com:xml-sql">
          exec CSM.dbo.querystrCR


-----Original Message-----
From: Brad Williams [mailto:brad.williams@xxxxxxxxxxxx]
Sent: Thursday, 10 February 2005 12:05 p.m.
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] Carriage return in XML


Add the below xslt after the end tag of the call that is generating the output
and you will get the desired results. The first is a CR and second is NL




-----Original Message-----
From: Matthew Day [mailto:mday@xxxxxxxxx]
Sent: Wednesday, February 09, 2005 2:34 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] Carriage return in XML


I am trying to generate a file of XML which is imported into a third party

So Far I have an wsh script

var xml= new ActiveXObject("Msxml2.DomDocument.4.0");
xml.async = false;
xml.preserveWhiteSpace = true;

XML template

<?xml version="1.0" encoding="UTF-8"?>
<csm xmlns:sql="urn:schemas-microsoft-com:xml-sql">
          exec CSM.dbo.querystrCR

So the XML file is created by accessing SQL server over http and saved
locally. In a web browser the xml looks identical to an example xml file which
can be imported into the app. However the xml file I generate will not import
into the app, and I've narrowed the problem to a CR (carriage
return) problem. I can manually add them in and it does import

In WordPad my XML looks like

But is should be like

Using google I see some other people with this problem and a solution of
<xsl:text></xsl:text> However I'm not sure how to impliment this into my
process. Any help appreciated. Cheers Matt

Current Thread