Hi guys - I'm having a compelte nightmare trying to remember XPath!!
Im not sure if what I'm trying to do is possible or not...
I'm using XPath in a bit of conditional XSL to try and determine whether or not to display a bit a text.
Basically I want to establish if there are any other "Employee" nodes in my XML with the same "EmployeeCode" value, but in a different "Section" parent node.
the XPath I have at the moment doesnt work:
count(../../../Section/Employees/Employee[EmployeeCode=EmployeeCode])> 1
If I just do:
count (EmployeeCode)
- result is 1 (current node as expected)
If I do:
count(../../../Section/Employees/Employee/EmployeeCode)
- result is 6 (all employees in my sample XML file)
If I do:
count(../../../Section/Employees/Employee[EmployeeCode=EmployeeCode])
- result in unforunately not 2 (the number of Employees with EmployeeCode same as current node) - but is 6 (presumabely the number of Employee whose EmployeeCode equals itself DOH!!)
How do I get a count of all the nodes that match the current one? Obviously my crude attempt at a value match didnt work cos the 2nd "EmployeeCode" still matches ALL the EmployeeCode nodes in the system...
thanks for your help!