|
Home > Archive > MS SQL XML > November 2006 > SQL Server XML output breaks RSS tags
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server XML output breaks RSS tags
|
|
| galvan.isaac@gmail.com 2006-11-28, 7:23 pm |
| Hello all... so I have SQL Server 2000 outputting information I need
from a database into an XML file for use in an rss feed. The XML is
valid, and I can view it in a browser. RSS readers won't take it
because SQL Server is inserting white space and carriage returns in
places, and while that does not cause a problem in the xml, rss readers
don't like it when there is a break in the rss tags. An example of the
output I'm getting:
<description> blah blah blah text text text</des
cription>
Anyone have any ideas as to how I may be able to fix this?
| |
| Peter W. DeBetta 2006-11-29, 7:19 pm |
| More info please, such as...
How are you outputting the xml data?
--
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
<galvan.isaac@gmail.com> wrote in message
news:1164756450.053889.269890@80g2000cwy.googlegroups.com...
> Hello all... so I have SQL Server 2000 outputting information I need
> from a database into an XML file for use in an rss feed. The XML is
> valid, and I can view it in a browser. RSS readers won't take it
> because SQL Server is inserting white space and carriage returns in
> places, and while that does not cause a problem in the xml, rss readers
> don't like it when there is a break in the rss tags. An example of the
> output I'm getting:
>
> <description> blah blah blah text text text</des
>
> cription>
>
> Anyone have any ideas as to how I may be able to fix this?
>
|
|
|
|
|