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

RE: Retrieve XML data from SQL 2000

• From: Michael Rys <mrys@m...>
• To: peter@s..., "Marcos A. Sanchez Rodriguez" <marcos@d...>
• Date: Fri, 13 Jul 2001 15:27:30 -0700

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@s...] 
> Sent: Friday, July 13, 2001 3:16 PM
> To: Marcos A. Sanchez Rodriguez
> Cc: xml-dev@l...
> 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@l...
> 

• Prev by Date: RE: building an object model of a XML schemas
• Next by Date: RE: Retrieve XML data from SQL 2000
• Previous by thread: Re: Retrieve XML data from SQL 2000
• Next by thread: RE: Retrieve XML data from SQL 2000
• Index(es):
  • Date
  • Thread