October 30, 2007 at 3:41 pm
I am having a small issue coming up with the correct structure of an XML Doc being returned by an SP in SQL 2000, I am using the EXPLICIT mode. The following is the format I am trying to get:
<root>
<node1 type="group">
<node2 type="text">some value </node2>
<node3 type="text">some value </node3>
</node1>
</root>
The following is what I can get without any problems:
<root>
<node1 type="group">
<node2>some value</node2>
<node3>some value</node3>
</node1>
</root>
Basically what I am missing is the type="text" in node2 and node3 elements. Is there anyway I can get this in there? If you can, please post an example.
Jason
October 30, 2007 at 3:47 pm
There's nothing here...
October 30, 2007 at 3:54 pm
Fixed the initial post, had an issue with posting the XML
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply