OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Retrieve XML data from SQL 2000

On Fri, 13 Jul 2001, Marcos A. Sanchez Rodriguez wrote:
> I need to retrieve XML data from a Microsoft SQL 2000 database with ADO 2.6.
> The tables can contains non XML valid character like "&" or "<".

If it is "XML data" as you say then it cannot contain "non XML
valid characters", so we must assume it is *not* XML data, right?

> How can I do this?

Write your extraction routines to include a filter which turns
& into &amp; and < into &lt; (in that order).