RE: [cf-xml] XPATH QUERY

[Brian LeGros]

Title: Message

Dave,

 

/reports/reportGroup[@name='one']

 

OR

 

/reports/reportGroup[normalize-space(@name)='one'] which trims leading and trailing whitespace

 

If a reportGroup can be found places other than below a reports tag, use //reportGroup instead of /reports/reportGroup.

 

Hope this helps.

 

Brian LeGros
Web Applications Manager
Foreign Currency Exchange Corporation
Information Technology
Email:  [EMAIL PROTECTED]
Phone:  954 - 749 - 0522
Fax:    800 - 323 - 4558

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave McLean
Sent: Tuesday, January 29, 2002 9:56 AM
To: '[EMAIL PROTECTED]'
Subject: [cf-xml] XPATH QUERY

Hi,

 

I have an XML file like the one below and I want to write an xpath query to bring back the report names of all the reports in the reportgroup where name = 'one'.

 

If I do //reportGroup[@name='one'] then I get data back for all the reports but only the text data such as that in <FieldList>. All I want is the name attribute for each report.

 

Can anyone help?

 

Thanks

 

Dave

 

<reports>
 <reportGroup name="one">

    <FieldList>f1,f2,f3,f4</FieldList>

...
  <report Name="a">
  </report>

  <report Name="b">

...
  </report>

 </reportGroup>

 <reportGroup name="two">

  <report Name="c">

...
  </report>

 </reportGroup>

</reports>

 

David McLean

Foundation Network Limited

Tel:        +44(0) 870 601 1090

Mobile:   +44(0) 788 162 4338

Mailto:    [EMAIL PROTECTED]

http://www.foundation-network.com

Relay(tm) - Partner Relationships- Managed