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.document Element.selectN odes("//products/group/product/stock")

I am using xmlDOC in an ASP script..

Thanks!

[mzmishra]

xmlDoc.getEleme ntsByTagName("p roduct ")[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.SelectNo des("product/@id") OR
xmlDoc.SelectSi ngleNode("produ ct/@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