FOR XML

From: Vinodh Kumar P (vinodh_at_here.com)
Date: 11/29/04


Date: Mon, 29 Nov 2004 16:34:08 +0530

Hello All,
    Using the following query "Select * from tblEmployees FOR XML"
how to retrieve the XML string from VC++?
I do not want to use save method of recordset.
Is there any way of exceuting the above query and getting the XML string?
I am using VC 6.0,ADO 2.6 and SQL server 2000.

Kind Regards,
Vinodh Kumar P



Relevant Pages

  • Re: XML and SQL2000
    ... you cannot query against XML strings in a SQL Server 2000. ... > information as a XML string stored in a field in the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Help with connection to WebServer via VB
    ... I need to connect Web Server, send a xml string ... I know the xml query string like: ... Could someone help plese? ...
    (microsoft.public.dotnet.languages.csharp)
  • Inserting XML String to a Text datatyped column
    ... I have an XML string that I get by using a query similar ... FROM ZipCodes where id < 3 ... This returns an XML string, ... Any kind of help in this regard will be grately ...
    (microsoft.public.sqlserver.xml)
  • LINQ to SQL as XML
    ... I have a LINQ class that I can use to query data from my database. ... want to query the data directly into an XML string without defining ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Pass Recordset from Web Service to Classic ASP.
    ... Use Interop on the server to work with the ADO recordset. ... > Set oStream = New ADODB.Stream ... > oStream.WriteText sXML 'Give the XML string to the ADO Stream ... > Set oRecordset = New ADODB.Recordset ...
    (microsoft.public.dotnet.framework.aspnet)