xml to asp?

[brakkie2]

Hi below is the xml data I get from a an asp page running on a server this asp page does a db query and senf this back. OK great so I've got this but how do I make sense of this xml so that i can write it into db on my machine. I'm anly familiar with asp and ado so please go slow. Thanks

<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">
- <s:AttributeType name="Id" rs:number="1" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="Ref_no" rs:number="2" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="float" dt:maxLength="8" rsrecision="15" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="CourseId" rs:number="3" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="RoleId" rs:number="4" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="UserId" rs:number="5" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="Orgin" rs:number="6" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="UFSno" rs:number="7" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="AdminNo" rs:number="8" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Enquiry_Date" rs:number="9" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Flag_Date" rs:number="10" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Appointment_Date" rs:number="11" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Credit_Followup" rs:number="12" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="FirstName" rs:number="13" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="LastName" rs:number="14" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="email1" rs:number="15" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="email2" rs:number="16" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="10" />
</s:AttributeType>
- <s:AttributeType name="IdPass" rs:number="17" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="StreetAddress1" rs:number="18" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="StreetAddress2" rs:number="19" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Suburb" rs:number="20" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="City" rs:number="21" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Province" rs:number="22" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Country" rs:number="23" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="ZipPostalCode" rs:number="24" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="WorkNo" rs:number="25" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="HomeNo" rs:number="26" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="CellNo" rs:number="27" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="FaxNo" rs:number="28" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="50" />
</s:AttributeType>
- <s:AttributeType name="Advertising" rs:number="29" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="Flag" rs:number="30" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="Credits_Flag" rs:number="31" rs:nullable="true" rs:maydefer="true" rs:writeunknown="true">
<s:datatype dt:type="int" dt:maxLength="4" rsrecision="10" rs:fixedlength="true" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row Id="259" Ref_no="20047192593" CourseId="1" RoleId="2" UserId="0" Orgin="0" Enquiry_Date="7/19/2004" Flag_Date="7/19/2004" FirstName="Francois" LastName="Viljoen" email1="francois@edegree.co.za" email2="francois@e" IdPass="54444444" StreetAddress1="5" StreetAddress2="5" Suburb="5" City="Johannesburg" Province="5" Country="South Africa" ZipPostalCode="1709" WorkNo="5" HomeNo="5" FaxNo="5" Advertising="0" Flag="1" Credits_Flag="0" />
<z:row Id="258" Ref_no="2004792583" CourseId="1" RoleId="2" UserId="1" Orgin="1" Enquiry_Date="7/9/2004" Flag_Date="7/9/2004" FirstName="Francois" LastName="Viljoen" email1="francois@edegree.co.za" email2="francois@e" IdPass="435435" City="Johannesburg" Country="South Africa" ZipPostalCode="1709" Advertising="0" Flag="1" Credits_Flag="0" />
</rs:data>
</xml>

 

[shatch]

There is a way, take a look at the source code available here:

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7190