Hello,

Using ASP I need to read a xml file and save the values in variables. The data in XML file is in following format:


 <CLIENT adSource="MSN" age="14">
  <PERSON SSN="00000345" lastName="Blood" firstName="Anderson" DOB="4/3/62" />
     <EMPLOYER name="The itHighway" position="clerk" payDays="">
       <PHONE type="Work" number="603-921-0677" />
       <PHONE type="Boss" number="603-924-0067" />
     </EMPLOYER>
 </CLIENT>


Any Idea..
Any Help...
Will be greatly appriciated.

Thanks!
Zeeshan Ahmed

__________________
Zeeshan Dar
itHighway
Get in Touch with People Texting your Website
Advanced Real Estate Listings Solution - FREE Hosting

This should get you started

Dim oXML, oClientNode, iClientAge
Set oXML = Createobject("MSXML2.DOMDocument.4.0")
oXML.Load(PATH_TO_FILE_ON_DISK)
Set oClientNode = oXML.selectSingleNode("//CLIENT")
iClientAge = oClientNode.getAttribute("age")
Set oXML = Nothing

Create an XML object, load your document, select a node with an XPath query, get an attribute from it.

Thanks tclancy. It worked.

How should I implement the loop if there are multiple records

Example:


<CLIENT adSource="MSN" age="14">
  <PERSON SSN="00000345" lastName="Blood" firstName="Anderson" DOB="4/3/62" />
     <EMPLOYER name="The itHighway" position="clerk" payDays="">
       <PHONE type="Work" number="603-921-0677" />
       <PHONE type="Boss" number="603-924-0067" />
     </EMPLOYER>
 </CLIENT>
<CLIENT adSource="Yahoo" age="24">
  <PERSON SSN="00000345" lastName="Blood" firstName="Anderson" DOB="4/3/62" />
     <EMPLOYER name="The itHighway" position="clerk" payDays="">
       <PHONE type="Work" number="603-921-0677" />
       <PHONE type="Boss" number="603-924-0067" />
     </EMPLOYER>
 </CLIENT>