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" rsrecision="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>
========================================
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" rsrecision="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>
========================================