XML - schema and data

microdevsolutions

Usenet Archive
Joined
May 25, 2005
Messages
4
Reaction score
0
Hello

I am wanting to cycle-through/parse the following XML and manipulate the values row by row via VBS and through DOM. This is not a problem however, as you can see the schema is before the data part of the XML. I'm not sure how to deal with this. Does anyone know how to read the schema then validate and read the data all contained the XML file.

Cheers
Travis

<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> <s:Schema id="RowsetSchema"> <s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30"> <s:AttributeType name="str1" rs:number="1" rs:writeunknown="true"> <s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="50" rs:maybenull="false" /> </s:AttributeType> <s:AttributeType name="num1" rs:number="2" rs:writeunknown="true"> <s:datatype dt:type="int" dt:maxLength="4" rs:precision="10" rs:fixedlength="true" rs:maybenull="false" /> </s:AttributeType> <s:AttributeType name="str2" rs:number="3" rs:nullable="true" rs:writeunknown="true"> <s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" />

</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
<rs:data>
<z:row str1="aaaa" num1="1111" str2="" />
<z:row str1="bbbb" num1="2222" str2="" />
</rs:data>
</xml>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
548,049
Messages
3,104,243
Members
248,133
Latest member
DujonT

Latest Threads

Top