-
XPath: Help please
I have xml with such syntax:
<Collection>
<Movie ID="0068646test">
<Title>123The Godfather</Title>
<Files>
<File>
<Part>1</Part>
<Path>C:\Movies</Path>
<Filename>mdfg1.avi</Filename>
</File>
</Files>
</Movie>
<Movie ID="0068646">
<Title>The Godfather</Title>
<Files>
<File>
<Part>1</Part>
<Path>C:\Movies</Path>
<Filename>movie.avi</Filename>
</File>
</Files>
</Movie>
</Collection>
I want to select all movies with filename "movie.avi".
I tryied
Set oXMLNodeList = oXMLDoc.selectNodes("/Collection/Movie[//Filename='movie.avi']") but it returns all movies. :(
Thank you for your help.
-
Re: XPath: Help please
Got it :)
Set oXMLNodeList = oXMLDoc.selectNodes("/Collection/Movie[Files/File/Filename='movie.avi']")