RE: [xsl] Carriage return in XML

Subject: RE: [xsl] Carriage return in XML
From: "Brad Williams" <brad.williams@xxxxxxxxxxxx>
Date: Wed, 9 Feb 2005 15:04:41 -0800
Matt,

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


	<xsl:text>&#xD;&#xA;</xsl:text>

Regards,

Brad


-----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

Hi

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

So Far I have an wsh script

var xml= new ActiveXObject("Msxml2.DomDocument.4.0");
xml.async = false;
xml.preserveWhiteSpace = true;
xml.load("http://localhost/routingtwo/template/test.xml";);
xml.save("testoutput.xml");


XML template

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

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
<csm>
	<field1>value</field1><field2>value</field2>
</csm>

But is should be like
<csm>
	<field1>value</field1>
	<field2>value</field2>
</csm>

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