XML - schema and data

M

microdevsolutions

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

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,065
Latest member
OrderGreenAcreCBD

Latest Threads

Top