Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sesh
Starting Member
2 Posts |
 Posted - 2002-04-16 : 05:46:43
|
| I am retreving an XML from SQLserver using "for XML".From VB6.0 we are retrieving the above said XML in "RecordsetObject.feilds(0)" into a string. The the extracted string is not holding the whole XML but a part of it only. We found that the resultant xml in SQL Query Analyser which has shown the XML in 4 lines and the VB Record set object in is holding the data till the end first line and the rest of the lines are truncated.later I Increased the No of Characters per line in Query Analyer to maximum(8192) but still i face the same problem. How do i hold whole XML in my string??? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-16 : 08:09:48
|
| I think you need to use an ADO Stream object instead of a recordset object when outputting XML. Every example I've seen uses an ADO Stream. Try these ASP sites for examples of this:www.4guysfromrolla.comwww.15seconds.comwww.asp101.comwww.aspalliance.comAlso be aware that the FOR XML clause does not create a root XML element, and the generated XML may or may not be usuable without it. |
 |
|
|
|
|
|
Problem in saving Queried XML into string