[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Retrieve XML data from SQL 2000

• From: Peter Flynn <peter@s...>
• To: "Marcos A. Sanchez Rodriguez" <marcos@d...>
• Date: Fri, 13 Jul 2001 23:15:40 +0100

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).

///Peter

• References:
  • Retrieve XML data from SQL 2000
    • From: "Marcos A. Sanchez Rodriguez" <marcos@d...>

• Prev by Date: RE: SAX2 ... missing features?
• Next by Date: RE: building an object model of a XML schema
• Previous by thread: Retrieve XML data from SQL 2000
• Next by thread: RE: Retrieve XML data from SQL 2000
• Index(es):
  • Date
  • Thread