RE: Retrieve XML data from SQL 2000

[Michael Rys <mrys@microsoft.com>]

SQLServer 2000's FOR XML and annotated schemata entitize automatically.
No need to write special filters.

Best regards
Michael

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