| Author |
OPENXML - Space preserve
|
|
| Nuno Teixeira 2005-07-26, 1:24 pm |
| Hi:
Have a problem in SQL Server 2000.
I'm using the OPENXLM method and i have some atributes with left white space.
I trying to put the xml: space="preserve" in the xml string, but it seems
that the OPENXML don't recognize him.
Please, anyone can help me?
Thaks.
Nuno Teixeira
Portugal
| |
|
|
| Can't use CDATA 2005-07-26, 8:24 pm |
| We can't use CDATA in attributes.
Nuno Teixeira has something like this:
<root>
<documento CTIPO=" A" NNUMDOC="5" NTIPO="D"><documento/>
<root/>
that's how documentdom from visual basic returns the xml!!
Thank you in advance,
Ricardo Silva
"markc600@hotmail.com" wrote:
>
> Check out this
>
> http://www.sqlxml.org/faqs.aspx?faq=78
>
>
| |
| Michael Rys [MSFT] 2005-07-27, 3:25 am |
| OpenXML's parser is performing attribute value normalizations that remove
whitespaces.
This is by design for OpenXML (at least by now, 5 years after release). In
SQL Server 2005, you can use the nodes() method to preserve the whitespace.
Best regards
Michael
"Can't use CDATA" <Can't use CDATA@discussions.microsoft.com> wrote in
message news:A1B90F00-9A1D-4B11-BCB6- 0316AB402045@microso
ft.com...[color=darkred]
> We can't use CDATA in attributes.
>
> Nuno Teixeira has something like this:
>
> <root>
> <documento CTIPO=" A" NNUMDOC="5" NTIPO="D"><documento/>
> <root/>
>
> that's how documentdom from visual basic returns the xml!!
>
>
> Thank you in advance,
> Ricardo Silva
>
>
> "markc600@hotmail.com" wrote:
>
|
|
|
|