What XPath can I use to select any category with a name attribute specified and any child node author with the value specified.
I've tried different variations of the path below with no success:
//quotes/category[@name='Sport' and author="James Small"]
The XML:
<?xml version="1.0" encoding="utf-8"?>
<quotes>
<category name="Sport">
<author>James Small<quote date="09/02/1985">Quote One</quote><quote date="11/02/1925">Quote nine</quote></author>
</category>
<category name="Music">
<author>Stephen Swann
<quote date="04/08/1972">Quote eleven</quote></author>
</category>
</quotes>
Try:
//category[@name='Sport' and ./author/text()='James Small']