[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??
<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??
Comment