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

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


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

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.


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