RE: Retrieve XML data from SQL 2000

[Joshua Allen <joshuaa@microsoft.com>]

FWIW, when you retrieve data from a SQL2000 database using FOR XML, for
example:

SELECT * FROM AUTHORS FOR XML AUTO

it will escape any such special characters automatically for you.  The
same should be true of the alternate route of getting a Recordset and
using:

rs.save stmOutput, adPersistXML

If you write your own routines to query the tables and generate XML, you
will of course have to write a filter to escape special characters.

Regards,
Joshua

> -----Original Message-----
> From: Peter Flynn [mailto:peter@silmaril.ie]
> Sent: Friday, July 13, 2001 3:16 PM
> To: Marcos A. Sanchez Rodriguez
> Cc: xml-dev@lists.xml.org
> Subject: 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).
> 
> ///Peter
> 
> ------------------------------------------------------------------
> The xml-dev list is sponsored by XML.org, an initiative of OASIS
> <http://www.oasis-open.org>
> 
> The list archives are at http://lists.xml.org/archives/xml-dev/
> 
> To unsubscribe from this elist send a message with the single word
> "unsubscribe" in the body to: xml-dev-request@lists.xml.org