RE: Carriage return in XML

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