How do I get this value?

[Pheddy]

Hello :D

Im getting into trouple with this one. Do anybody know how to extract the ID (<product id="506343242">) in this XML file?

<?xml version="1.0" encoding="ISO-8859-1"?>
<products xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="oemPriceXMLList.xsd">
 
<group name="">
</group>
<group name="Some Soft">
<product id="506343242">
<name>Adobe Acrbobat 9</name>
<stock>Yes</stock>
<weight>0.5</weight>
<model>6504543534</model>
<shortDescription>DESCRIPTION</shortDescription>
<manufacturerName>Adobe</manufacturerName>
<manufacturerURL>http://www.adobe.com/</manufacturerURL>
<price>300</price>

I can retrieve the other values by using xmlDOC.documentElement.selectNodes("//products/group/product/stock")

I am using xmlDOC in an ASP script..

Thanks!

[mzmishra]

xmlDoc.getElementsByTagName("product ")[0].getAttribute("id")

[Pheddy]

I got this error when using

objNodeList9 = xmlDoc.getElementsByTagName("product")[0].getAttribute("id")

Microsoft VBScript compilation error '800a0401' 
 
Expected end of statement 
 
/xml.asp, line 42 
 
Set objNodeList9 = xmlDoc.getElementsByTagName("product")[0].getAttribute("id")
 
 

So I tried:

xmlDoc.getElementsByTagName("product").getAttribute("id")

But got this error

Microsoft VBScript runtime error '800a01b6' 
 
Object doesn't support this property or method: 'getAttribute' 
 
/xml.asp, line 42 
 

[Oralloy]

This is gonna sound dumb, but are you missing a semicolon or other statement terminator?

Also, in VBA, which is what I'm familiar with, the appropriate verb is "Let" for value assignment - "Set" is used for object assignment.

[Pheddy]

.. No I cant find any of those error, maybe my version is somewhat wrong?

I am using (in ASP)

Set HTTP         = CreateObject("MSXML2.XMLHTTP")
Set xmlDOC        = CreateObject("MSXML.DOMDocument")

[Oralloy]

Did you try using Let, not Set?

Let objNodeList9 = xmlDoc.getElementsByTagName("product")[0].getAttribute("id")

[Pheddy]

That dosnt work.. Anyother bids??

[jkmyoung]

What version of ASP?

xmlDoc.SelectNodes("product/@id") OR
xmlDoc.SelectSingleNode("product/@id")

[Pheddy]

I am using Classic Asp.

Again I Get errors...

With

  Set objNodeList9    = xmlDoc.SelectSingleNode("product/@id")
    Response.Write objNodeList9(i).nodeValue & "<br>"

I get:

Microsoft VBScript runtime error '800a000d' 
 
Type mismatch 
 

And with

  Set objNodeList9    = xmlDoc.SelectNodes("product/@id")
    Response.Write objNodeList9(i).nodeValue & "<br>"

I get:

Microsoft VBScript runtime error '800a01a8' 
 
Object required: '[object]' 
 

[Pheddy]

So I found the answer!

Here it is:

  Set objNodeList8    = xmlDOC.documentElement.selectNodes("//products/group/product/@id")
    Response.Write objNodeList8(i).text & "<br>"

Thanks for all replies!

-Frederik