How to Parse XML in ASP?
 

Hey guys,
I'm having a "great" pleasure of parsing XML in my ASP page, except I can't seem to figure it out what I'm doing wrong. I have tried a bunch of stuff and can't seem to read a simple xml doc. here is what my code looks like...

' Create new XML reader object

Dim xmlDoc

Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")



' Load the specified XML file (returns XML output)

xmlDoc.load("http://somesite.com/api/xml?action=login&login=jon@doe.com&password=foobar")



' Parse XML

if xmlDoc.parseError.errorcode <> 0 then

  ' oops error in xml

  Response.Write("XML Error...<br>")

else

  ' get xml data

  Response.Write(xmlDoc.documentElement.childNodes(0).attributes.getNamedItem("code").nodeValue)

end if

my xml looks like this...

<?xml version="1.0" encoding="utf-8"?>

<results>

        <status code="value"/>

</results>

and my error is...
This is my first time working with XML in ASP, so it is possible i'm missing something simple, any ideas what's going wrong here?

Thanks

Re: How to Parse XML in ASP?
 

I've figured it out and just in case someone else is forced to use ASP to process XML...

The code above WORKS on an XML document on the server, but if you are like me and you're trying to read XML document from a response stream the following code does the trick...

set xmlDoc = createObject("MSXML2.DOMDocument")



xmlDoc.async = False

xmlDoc.setProperty "ServerHTTPRequest", true

xmlDoc.load("http://somesite.com/api/xml?action=login&login=jon@doe.com&password=foobar")



response.write xmlDoc.selectSingleNode("//results/status").Attributes.GetNamedItem("code").Text

Cheers!

Re: How to Parse XML in ASP?
 

I am having to send a form to a 3rd party server, the server will respond with a XML validation and policy number. I need to then parse this XML response with ASP into my own webpage.

The info you have given so far seems to be what I need but I can't get it to work. Can you give more information on what you did to parse the XML, including ASP and XML code samples?

Much appreciated!!!