August 23, 2002 at 7:47 am
I tried the SQL feature of generating XML from the query using FOR XML EXPLICIT. But when I am trying to get it to the programming interface using VB 6; the xml generated is being stored in a very different form. I am not able to reslove it to be stored as just a string.
If anybody is worked on it pls let me know the methodology.
August 23, 2002 at 9:13 am
You might have better luck using SAVEASXML in the recordset object of ADO (2.6 and higher)
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961
August 23, 2002 at 10:43 am
The XML usually comes back as a single result set or a stream. You have to work with it differently.
ADO has a method to convert it. Check the 4guysfromrolla.com or other sites for some ASP code to do this.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply