Problem with XQuery

nelly78 · January 20th, 2010, 05:13 PM

Hi All,
I am writing below Xquery to retireive data from XML document given below but its returning duplicate data. I just want one pair of record instead of two pair.
Here is the XQuery :
[code]
<html>
{

for$v in
doc("Hierarchy.xml")/Hierarchy/Branch[@Id="Tree2"]
for$l1 in$v/Node/*
for$x indoc("Hierarchy.xml")/Hierarchy/Branch
for$l2 in$x/Node/*for$z indoc("Hierarchy.xml")/Hierarchy/Branch[@Id=$l2/@Connection]
for$l3 in$z/Node/*
for$y indoc("Hierarchy.xml")/Hierarchy/Branch[@Id=$l3/@Connection]
for$l4 in$y/Node/*[@Connection="SmallPlant1"

mhkay · January 20th, 2010, 07:10 PM

Sorry, but your code is not legible and is apparently incomplete: please use the square-bracket code tags appearing in the instructions for this forum.

By the looks of it, even when you fix this, it may be difficult to help - try to simplify the problem if you can, to get to the essence of the issue