xsl-list
[Top] [All Lists]

RE: Carriage return in XML

2005-02-09 16:28:50
Hmm

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">
          <sql:query>
          exec CSM.dbo.querystrCR
     </sql:query>
</CSM>

Cheers
Matt

-----Original Message-----
From: Brad Williams [mailto:brad(_dot_)williams(_at_)riverone(_dot_)com] 
Sent: Thursday, 10 February 2005 12:05 p.m.
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] 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(_at_)wxc(_dot_)co(_dot_)nz] 
Sent: Wednesday, February 09, 2005 2:34 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--


--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--


--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>