Please Help with the Xpath...

[supergreat]

Could someone help me with the XPath to select LastName from the below
xml without duplicating the name.
Note: There are two cities in the above tree that have the same
information, I just want to pick one, not the two,
and I want my select to check the two cities and just pick one... Here
is the one I wrote, It pick up two, I just
want one

/Residence/*/City[@id='16']/LastName
'Brown'
'Brown'
<Residence>
<California>
<City active="true" id="16">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
<City active="true" id="17">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
</California>
<Colorado>
<City active="true" id="16">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
<City active="true" id="17">
<FirstName>Mary</FirstName>
<LastName>Bob</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
</Colorado>
</Residence>

--
supergreat
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message113822.html

[Patrick TJ McPhee]

In article <su***************@mail.forum4designers.com>,
supergreat <su***************@mail.forum4designers.com> wrote:

[...]
% and I want my select to check the two cities and just pick one... Here
% is the one I wrote, It pick up two, I just
% want one
%
% /Residence/*/City[@id='16']/LastName
% 'Brown'
% 'Brown'

How about

/Residence/*/City[@id='16'][1]/LastName

? That's untested, but it should pick up the first city in the list.
--

Patrick TJ McPhee
East York Canada
pt**@interlog.com

[Marrow]

Hi,

As a pure XPath expression try something like...

/Residence/*/City[@id='16']/LastName[not(. =
.../../preceding-sibling::*/City[@id = '16']/LastName)]

However, if you are doing this within XSLT then using XPath (and axes) to
obtain distinct values is rarely the most efficient method.

HTH
Marrow
http://www.marrowsoft.com - home of Xselerator (XSLT IDE and debugger)
http://www.topxml.com/Xselerator

"supergreat" <su***************@mail.forum4designers.com> wrote in message
news:su***************@mail.forum4designers.com...

Could someone help me with the XPath to select LastName from the below
xml without duplicating the name.
Note: There are two cities in the above tree that have the same
information, I just want to pick one, not the two,
and I want my select to check the two cities and just pick one... Here
is the one I wrote, It pick up two, I just
want one

/Residence/*/City[@id='16']/LastName
'Brown'
'Brown'
<Residence>
<California>
<City active="true" id="16">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
<City active="true" id="17">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
</California>
<Colorado>
<City active="true" id="16">
<FirstName>James</FirstName>
<LastName>Brown</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
<City active="true" id="17">
<FirstName>Mary</FirstName>
<LastName>Bob</LastName>
<Phone>[phone]</Phone>
<Fax>[phone]</Fax>
</City>
</Colorado>
</Residence>

--
supergreat
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message113822.html