Retrieving SQL 2000 'For XML' statement

Article View: borland.public.cppbuilder.database.ado

Article #5717

Back to borland.public.cppbuilder.database.ado Previous Next

#5717

From: Lyle Mix
Date: Thu, 22 Feb 2001 23:39

4 lines
1121 bytes

I am trying to retrieve a table record as XML under SQL 2000.  Using the ADO driver and connection, I can get a column returned, however it appears as a blob.  I am having trouble getting at the actual XML string inthe underlying data.

Does anyone know how to do this?

Technical Details

Message-ID: <3a95a323$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out.usenetserver.com!news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!207.105.83.65

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3598342d64c791ac,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-22 15:44:06 PST
From: "Lyle Mix" <lyle.mix@shaw.ca>
Sender: "Lyle Mix" <lyle.mix@shaw.ca>
Reply-To: "Lyle Mix" <lyle.mix@shaw.ca>
Subject: Retrieving SQL 2000 'For XML' statement
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 204.209.209.129 204.209.209.129    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3a95a323$1_1@dnews>
Date: 22 Feb 2001 15:39:15 -0800
X-Trace: 22 Feb 2001 15:39:15 -0800, 207.105.83.65
Lines: 4
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out.usenetserver.com!news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!dnews!207.105.83.65