How to Parse XML in ASP?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 402,747 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,530 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 26944 | Replies: 2

•

Join Date: Jun 2005

Location: Seattle, WA

Posts: 53

Reputation: senexom is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

senexom

Offline

Junior Poster in Training

How to Parse XML in ASP?

Aug 8th, 2005

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...

Help with Code Tags

(Toggle Plain Text)

' 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...

Help with Code Tags

(Toggle Plain Text)

<?xml version="1.0" encoding="utf-8"?>
<results>
	<status code="value"/>
</results>

and my error is...

•

Microsoft VBScript runtime error '800a01a8'

Object required: 'documentElement'

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

•

Join Date: Jun 2005

Location: Seattle, WA

Posts: 53

Reputation: senexom is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

senexom

Offline

Junior Poster in Training

Re: How to Parse XML in ASP?

Aug 9th, 2005

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...

Help with Code Tags

(Toggle Plain Text)

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!

•

Join Date: Jun 2007

Posts: 1

Reputation: dude9er is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

dude9er

Offline

Newbie Poster

Re: How to Parse XML in ASP?

Jun 29th, 2007

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!!!