|
Home > Archive > MS SQL XML > November 2005 > VBscript is stripping away xhtml format
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 |
VBscript is stripping away xhtml format
|
|
|
| I have a VBScript that imports a xml document into a sql server database,
which will eventually serve as the backend to our website.
Some of the data inside an xml tag is formatted in xhtml (i.e. it has <p>,
<ul>, <b> tags).
I notice that when I run the script and look at the web pages, the xhtml
tags are gone and the page is displaying the text as one big paragraph.
What do I need to do in order to retain the xhtml format?
| |
| Michael Rys [MSFT] 2005-11-03, 8:27 pm |
| How do you get it back? How does the query look like?
Thanks
Michael
"mb525" <mb525@discussions.microsoft.com> wrote in message
news:886D7EC4-32D8-40AE-BFCA- FF25AB5C2259@microso
ft.com...
>I have a VBScript that imports a xml document into a sql server database,
> which will eventually serve as the backend to our website.
>
> Some of the data inside an xml tag is formatted in xhtml (i.e. it has <p>,
> <ul>, <b> tags).
>
> I notice that when I run the script and look at the web pages, the xhtml
> tags are gone and the page is displaying the text as one big paragraph.
>
> What do I need to do in order to retain the xhtml format?
>
| |
|
| Actually I have figured out how to do it.
Using the <![CDATA[text with the html tags]]>.
Now what I am trying to do is preformat certain xml tags in a schema file so
that it will know to use the cdata section. I'm pretty new with creating
schema files. Does anyone have suggestions on the best way to go about this?
Thanks,
Monica
"Michael Rys [MSFT]" wrote:
> How do you get it back? How does the query look like?
>
> Thanks
> Michael
>
> "mb525" <mb525@discussions.microsoft.com> wrote in message
> news:886D7EC4-32D8-40AE-BFCA- FF25AB5C2259@microso
ft.com...
>
>
>
| |
| Michael Rys [MSFT] 2005-11-04, 3:23 am |
| It has been too long since I did annotated schemas.
I think there is an annotation that designates that you the data should use
cdata sections.
I am still not sure however, why the CDATA section would help over having
the <>& etc. entitized. In either case the data is not markup but only
character data.
Best regards
Michael
"mb525" <mb525@discussions.microsoft.com> wrote in message
news:A7021EE8-8668-40D6-8737- F4710DE721EA@microso
ft.com...[color=darkred]
> Actually I have figured out how to do it.
> Using the <![CDATA[text with the html tags]]>.
>
> Now what I am trying to do is preformat certain xml tags in a schema file
> so
> that it will know to use the cdata section. I'm pretty new with creating
> schema files. Does anyone have suggestions on the best way to go about
> this?
>
> Thanks,
>
> Monica
>
> "Michael Rys [MSFT]" wrote:
>
|
|
|
|
|