[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Retrieve XML data from SQL 2000
- From: Peter Flynn <email@example.com>
- To: "Marcos A. Sanchez Rodriguez" <firstname.lastname@example.org>
- 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 & and < into < (in that order).