How to Parse XML in ASP

**Dwarner** · 24-01-2010

Hi ,

I am using ASP as a business logic in one of my project. I want to parse XML code in ASP, But it reflects with an error :

Code:

Microsoft VBScript runtime error '800a01a8'
Object required: 'documentElement'

My ASP code is :

Code:

 Dim xmlDoc123
 Set xmlDoc123 = Server.CreateObject("Microsoft.XMLDOM")
 xmlDoc.load("http://mysite.com/api/xml?action=login&login=abc@xyz.com&password=123456")
Parse XML
if xmlDoc.parseError.errorcode <> 0 then
      ' oops error in xml
      Response.Write("XML Error...<br>")
      else
     ' get xml data
Response.Write(xmlDoc123.documentElement.childNodes(0).attributes.getNamedItem("code").nodeValue)
      end if

and my XML code is

Code:

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

Please suggest.

**Praetor** · 24-01-2010

You need to try this code, it will work with me.

Code:

<%
Option Explicit
Response.Buffer = True

Dim xml123
	Set xml123 = Server.CreateObject("Microsoft.XMLDOM")
	xml123.async = False
	xml123.load (Server.MapPath("mypage.xml"))

Dim title123, heading123, paragraph123, testHTML123
	title123 = xml123.documentElement.childNodes(0).text
	heading123 = xml123.documentElement.childNodes(1).text
	paragraph123 = xml123.documentElement.childNodes(2).text
	testHTML123 = xml123.documentElement.childNodes(3).text

	Set xml123 = Nothing
%>
<html>
<head>
	<title123><%= title %></title123>
</head>
<body>
<h3 align="center"><%= heading123 %></h3>
<p align="center"><% = paragraph123 %></p>
<div align="center"><%= testHTML123 %></div>
</body>
</html>

**Katty** · 24-01-2010

I parse XML using XSL stylesheets via ASP in y project, Try it and reply.

Code:

<%
xmlf = "example123.xml"
stylef = "example123.xsl"		
set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")
set xslDoc = Server.CreateObject("Microsoft.XMLDOM")	
xmlDoc.load(Server.Mappath(xmlf))
xslDoc.load(Server.Mappath(stylef))
Response.Write(xmlDoc.transformNode(xslDoc))
%>

**kelfro** · 24-01-2010

There are several ways that you parse XML code in ASP. Try this.

ASP Syntax

Code:

set objXMLRoot = xmlDoc.selectSingleNode("//results123/data123")
set objXMLRoot = xmlDoc.selectSingleNode("//results123/data123")
if not (objXMLRoot is nothing) then
for each objNode in objXMLRoot.childNodes()
response.write objNode.text
next
end if

**Zecho** · 24-01-2010

I have tried to pull out some nodes from an xml string, lets try the below code.

Code:

Set xml123  = Server.CreateObject("MSxml2.FreeThreadedDomDocument.3.0")
xml.async = False
xml.loadxml(xmlhttp.responseText)
Set root = xml.documentElement
Set hotelname123 = root.selectNodes("abddef")
clientid123 = name.selectSingleNode("response/customer/clientId123").text
totalrate123 = name.selectSingleNode("response/rateinfo/totalRate123").text
hotelid123 = name.selectSingleNode("request/hotelID123").text
confid123 = name.selectSingleNode("response/confirmationNumber123").text
Next
response.write(clientid123 & totalrate123 & hotelid123 & confid123)