Beginner Xpath Query

[simonchristieis]

I have an xml file

<aaa>
<bbb>
<name>Billy</name>
<age>34</age>
<telephone>123</telephone>
</bbb>
</aaa>


and am running an xpath query against it, but i cant return specific details


set xmlDoc=CreateObject(&quot;Microsoft.XMLDOM&quot
xmlDoc.async=&quot;false&quot;
xmlDoc.load(&quot;xml/contact.xml&quot

i=&quot;Billy&quot;


' Xpath Query
set nodes=xmlDoc.selectNodes(&quot;aaa/bbb[name='&quot; & i & &quot;']/*&quot


****** this is where the problem lies
****** I want to return the value of telephone

html = nodes.item('telephone').text


alert(html)

id be grateful for any help

thanks in advance

 

[culshaja]

You missed the @ infront of name. The statement you want should be:

set nodes=xmlDoc.selectNodes("/aaa/bbb[@name='" & i & "']/*")

James

James Culshaw
james@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.caninerescue.co.uk

 

[Hexonx]

this worked for me (as a vbscript file):

dim xmlDoc, nodes, i, html

set xmlDoc=CreateObject(&quot;Microsoft.XMLDOM&quot
xmlDoc.async=false
xmlDoc.load(&quot;contact.xml&quot

i=&quot;Billy&quot;

html = xmlDoc.selectSingleNode(&quot;aaa/bbb[name='&quot; & i & &quot;']/telephone&quot.text
msgbox html


Your problem is on this line:
html = nodes.item('telephone').text

The item collection takes only an integer. Since I don't like 'magic numbers', I prefer to use the selectSingleNode method with explicit element names.