Very Computer

I see that SQL2000 lets me retrieve XML using FOR XML AUTO

How do I call this from ASP/COM? If I open a recordset that runs "SELECT *
FROM Table FOR XML AUTO"
How do access the XML in the recordset ie
Response.write rsTemp.**** ?

Hope this makes sense.

Sam

Hi,

I had some problems retrieving the xmldata at first but this code works
fine:

Replace(RS.GetString, Chr(13), "")

The replacefunction is used to delete the linefeed that for some reason is
inserted when the xmlstring becomes to long...

/Martin

Quote:> I see that SQL2000 lets me retrieve XML using FOR XML AUTO

> How do I call this from ASP/COM? If I open a recordset that runs "SELECT *
> FROM Table FOR XML AUTO"
> How do access the XML in the recordset ie
> Response.write rsTemp.**** ?

> Hope this makes sense.

> Sam

Thanks for the answer Martin

How do I refernce the XML in the recordset. If I wanted to write it out, how
would I reference the XML in the recordset to manipulate it?

ie
Dim rsTemp
Set rsTemp = oConn.execute("SELECT * FROM Table FOR XML AUTO")
response.write rsTemp??????

Thanks

Sam

Hi

Like this:

response.write Replace(RS.GetString, Chr(13), "")
Or just:
response.write RS.GetString '(but look out for linefeeds!)

| How do I call this from ASP/COM? If I open a recordset that runs "SELECT *
| FROM Table FOR XML AUTO"
| How do access the XML in the recordset ie
| Response.write rsTemp.**** ?

I don't think you're supposed to use a Recordset object but rather a Stream
object. I'm not a VB person (VC instead), but this is what I'm seeing from
my digs through MSDN. Now if someone could post how this needs to be done in
VC, that would be great. The docs in MSDN are pretty sparse when in comes to
VC++ and ADO/SQL Server 2K programming.

greg

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

I have answered this already in microsoft.public.xml.

You can retrieve XML stream only through stream object.
Example:

    Set conn = New ADODB.Connection
    conn.Open strYourConnectionString
    Set str = New ADODB.Stream
    str.Mode = adModeRead
    str.Open
    Set cmd = New ADODB.Command
    Set cmd.ActiveConnection = conn
    cmd.CommandText = "Your_stored_proc_with_XML_AUTO"
    cmd.CommandType = adCmdStoredProc
    cmd.Properties("Output Stream").Value = str
    cmd.Execute , , adExecuteStream
    strXML = str.ReadText(-1)

--
Mikhail Berlyant
Brainbench MVP for Visual Basic
http://www.brainbench.com
Distribution Systems Lead, Data Systems
http://www.launch.com

Quote:> I see that SQL2000 lets me retrieve XML using FOR XML AUTO

> How do I call this from ASP/COM? If I open a recordset that runs "SELECT *
> FROM Table FOR XML AUTO"
> How do access the XML in the recordset ie
> Response.write rsTemp.**** ?

> Hope this makes sense.

> Sam

Hi I have problems at this line:

cmd.Properties("Output Stream").Value = str

the message is:

ADODB.Command Error '800a0cc1'
item cannot be found in the collection corresponding to the requested name or ordinal.

How should I overcome this? Thanks!

Please Visit My *!!
http://www.veryComputer.com/

*** Sent via Developersdex http://www.veryComputer.com/ ***
Don't just participate in USENET...get rewarded for it!