We help IT Professionals succeed at work.

Classic ASP and XML - Selecting a specific node

nthawkins1971
nthawkins1971 asked
on
Hi, I' need to select a specific node in an xml doc... i have this which gives me everything

For Each xmlNode In objXML.documentElement.selectNodes("Data")

but i need a single node and its related nodes that has a specific value.. please see the xml

for example: I need to select only the Data where Bookcode = NEA-CSOP

Thank you

<DocumentElement>
<Data>
  <BookCode>NEA-CSOP</BookCode>
  <BPSday>3</BPSday>
  <BPSwk>6</BPSwk>
  <BPSmth>8</BPSmth>
  <Trackday>-44.6</Trackday>
  <TrackPnL>0</TrackPnL>
  <WAIVImv>0.239</WAIVImv>
  <WAIVexp>0.252</WAIVexp>
  <x90Day>0.256</x90Day>
</Data>

<Data>
<BookCode>NEA-EA1</BookCode>
<BPSday>18</BPSday>
<BPSwk>39</BPSwk>
<BPSmth>44</BPSmth>
<Trackday>-23.5</Trackday>
<TrackPnL>0</TrackPnL>
<WAIVImv>0.219</WAIVImv>
<WAIVexp>0.217</WAIVexp>
<x90Day>0.256</x90Day>
</Data>

<Data>
<BookCode>NEK-MV4</BookCode>
<BPSday></BPSday>
<BPSwk></BPSwk>
<BPSmth></BPSmth>
<Trackday></Trackday>
<TrackPnL></TrackPnL>
<WAIVImv></WAIVImv>
<WAIVexp></WAIVexp>
<x90Day></x90Day>
</Data>
<DocumentElement>

Open in new window

Comment
Watch Question

View Solution Only

Flabio Gates

Commented:
Can you try:
For Each xmlNode In objXML.documentElement.selectNodes("Data[text()='NEA-CSOP']")

Open in new window

nthawkins1971

Author

Commented:
Doesn't seem to work, however it doesnt cause an error.. should I add BookCode in some way... like, Data.BookCode[text()='NEA-CSOP' ?


For Each xmlNode In objXML.documentElement.selectNodes("Data[text()='NEA-CSOP']")
Flabio Gates

Commented:
Data/BookCode[text()='NEA-CSOP']
Flabio Gates

Commented:
But that would get you the BookCode node.
You'll need to get back up 1 level to the Data node.
Not sure as I'm on my phone but it would look like
Data/BookCode[text()='NEA-CSOP']/parent-node::*
Ryan ChongSoftware Team Lead

Commented:
try this instead.

Data[BookCode/text()='NEA-CSOP']

Open in new window

nthawkins1971

Author

Commented:
Absolutely perfect! thanks
Commented:
was almost there:
Data/BookCode[text()='NEA-CSOP']/parent::*

Open in new window

Ryan ChongSoftware Team Lead

Commented:
well, absolutely perfect but yet not accepted as answer?