Read xml data

itHighway · November 15th, 2008, 06:29 PM

I have following xml file, which I am trying to read with ASP code:

Quote:

quote:<?xml version="1.0" ?>

Quote:

Following is the ASP code, I am trying to use:

Quote:

quote:Dim oXML, xmlC, txtContinentName

Quote:

    Set oXML = Server.CreateObject("Microsoft.XMLDOM")
    oXML.async = False
    oXML.load (adPhysicalFlash & "countryindex.xml")

    set xmlC = oXML.selectNodes("//data/continent1")

    txtContinentName = xmlC.getAttribute("listings").text

response.Write(txtContinentName)

www.ithighway.co.uk

Old Pedant · November 16th, 2008, 02:44 AM

Ummm...why would you think that "continent1" and "continent" would be the same thing???

Computers don't care whether you misspell by 1 letter or by 97 letters; if there's any difference AT ALL, the two strings are not the same.

And then, once you fix that, you need to understand the xmlC is going to be a *collection* of nodes. So how can you ask to get *ONE* attribute from an entire collection of nodes?

On top of that, why would you think that the attribute named "listings" would hold a continent name when clearly each of those tags says
listings="0"
???

So *PROBABLY* you need code *SOMETHING* like this:

Code:

...
Set oXML = Server.CreateObject("Microsoft.XMLDOM")
oXML.async = False
oXML.load (adPhysicalFlash & "countryindex.xml")

set xmlC = oXML.selectNodes("//data/continent")
For nnum = 0 To xmlC.length-1
    set cont = xmlC(nnum)
    cname  = cont.getAttribute("name").text
    Response.Write "Continent: " & cname & "<BR>" & vbNewLine
Next
...
%>

itHighway · December 1st, 2008, 02:38 PM

Thanks for you response. I used your code and get the error on following line:

cname = cont.getAttribute("name").text

The error is:

Microsoft VBScript runtime (0x800A01A8)
Object required: '[string: "South America"]'

Please advice.

www.ithighway.co.uk

Old Pedant · December 1st, 2008, 04:09 PM

I think an attribute is *ALREADY* a string, so the ".text" there is extraneous. Try without it:
cname = cont.getAttribute("name")

I'd try it but don't have time right this minute.

itHighway · December 2nd, 2008, 04:46 AM

Excellent. It worked. Thanks!

www.ithighway.co.uk