Re: Find the Position Index of Elements‏‏

Play the video

Subject: Re: Find the Position Index of Elements‏‏
From: David Carlisle <davidc@xxxxxxxxx>
Date: Sun, 13 Jun 2010 22:48:51 +0100

On 13/06/2010 20:43, Alice Wei wrote:

Hi,

I have an XML snippet as in the following:

<music_songs>
   <song>
     <title>(I Just) Died In Your Arms</title>
     <category>Rock</category>
     <album>80 Popular Hits</album>
     <artist>Cutting Crew</artist>
     <date added="03-24-2009"/>
   </song>
   </music_songs>

This is one of the songs out of categories I have in my xml file, and
currently I use XPath expression as in the following:
/music_songs/song[category='Rock' as an example to find all the songs
in the Rock category.

whenever you use /a/b/c/[something='zzz']

you should think of doing

key('x','zzz')

instead, it can be surprising the speedup you can get


I need to also be able to pull the position index of the song elements
that I pull from the above expression, and use that in VB.NET for
process. I tried using count(), position(), but they seem to be able
to detect, but they cannot give me a list like

you don;t say if you are using xslt 1 or 2.

xslt 1 doesn't have a datatype that can store a sequence of integers.
You can get the numbers as for example

<xsl:for-each select="/music_songs/song[category='Rock']">

and then use

<xsl:number/>

or <xsl:value-of select="count(preceding-sibling::song[category='Rock'])+1)"/>

Ib xslt2 you can store a list of integers

/music_songs/song[category='Rock']/count(preceding-sibling::song[category='Rock'])+1)

for example would work (although is paerhaps rather inefficient)

David

Current Thread
Find the Position Index of Elements‏‏ Alice Wei - 13 Jun 2010 19:43:41 -0000 David Carlisle - 13 Jun 2010 21:49:13 -0000 <= Philip Fearon - 13 Jun 2010 22:15:12 -0000 Alice Wei - 13 Jun 2010 22:26:32 -0000 Michael Kay - 13 Jun 2010 22:58:33 -0000 Alice Wei - 13 Jun 2010 23:15:31 -0000

<- Previous	Index	Next ->
Find the Position Index of E, Alice Wei	Thread	Re: Find the Position Index o, Philip Fearon
Find the Position Index of E, Alice Wei	Date	Re: distinguish whether varia, TW
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >