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 |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2002-04-11 : 08:07:33
|
| the for xml clause will return in xml format.in VB if set the commandtext to "select * from ... for xml auto,elements'how will i get the result back |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-11 : 08:19:57
|
| The results are "streamed" back to the VB program as XML, basically as one large string value. If you use the ADO Stream object to read it, then you can use the XML DOM methods to load and navigate the stream as a normal XML document.Check out these ASP sites for more info, they have examples on using Streams and XML:www.4guysfromrolla.comwww.15seconds.comwww.asp101.comwww.aspalliance.com |
 |
|
|
|
|
|
vb ,xml ,sql