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
recision="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" rs
</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>