XPATH query (count)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • panos100m
    New Member
    • Aug 2007
    • 23

    XPATH query (count)

    [code=xml]
    <root>
    <row>
    <col name="Surname"> McEnroe</col>
    <col name="Postcode" >44312</col>
    <col name="PolicyID" >X1234565V</col>
    </row>
    <root>
    <row>
    <col name="Surname"> McEnroe</col>
    <col name="Postcode" >44312</col>
    <col name="PolicyID" >X1234565V</col>
    </row>
    <row>
    <col name="Surname"> Green</col>
    <col name="Postcode" >44123</col>
    <col name="PolicyID" >A65432123M</col>
    </row>
    <row>
    <col name="Surname"> Green</col>
    <col name="Postcode" >SW932P</col>
    <col name="PolicyID" >A6543212333M </col>
    </row>
    </root>
    [/code]

    Hi I need to write a xpath query that return the number of results (count) with a given surname and postocode .eg for Green and 44123 will return 1 but for McEnroe and 44312 will return 2 ....

    I tried and tried but I cant get it to work any ideas??
  • jkmyoung
    Recognized Expert Top Contributor
    • Mar 2006
    • 2057

    #2
    [code=xml]count(/root/row[col[@name='Surname']='Green'][col[@name='PostCode ']='44123'])[/code]

    Comment

    Working...