RE: [xsl] Carriage return in XML

Subject: RE: [xsl] Carriage return in XML
From: Pieter Reint Siegers Kort <pieter.siegers@xxxxxxxxxxx>
Date: Wed, 9 Feb 2005 17:19:32 -0600
Hi Matthew,

Actually this is not a XSLT question; I see you're using SQLXML, so to
change your XML input source you'll need to change the way SQL returns the
XML. There are different formats in which SQL can return XML, see the books

The solution you read was about XSLT and that is outside your process.


-----Original Message-----
From: Matthew Day [mailto:mday@xxxxxxxxx] 
Sent: Wednesday, February 09, 2005 4: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
Any help appreciated.

Current Thread