[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Retrieve XML data from SQL 2000
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@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 & and < into < (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...
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|