Subject: Re: [xsl] Find the Position Index of Elements From: Michael Kay <mike@xxxxxxxxxxxx> Date: Sun, 13 Jun 2010 23:58:07 +0100 |
Right, I am not intending to use this in the xsl at all, and I am trying to use this in VB.NET in ASP. I am trying to come up with some way so I can figure out how to extract the position node of the elements from my xml so I can use them to use pagination.
I tried David's solution, and somehow that didn't work, it now gives
me this error on tokenizer issues, and I am not sure if what I trying
to do is even possible at all.
Michael Kay Saxonica
Alice
On Sun, Jun 13, 2010 at 6:14 PM, Philip Fearon<pgfearo@xxxxxxxxxxxxxx> wrote:
Though this is the xsl-list, you haven't mentioned XSLT, so this answer is just in case you wanted an XPath / .NET solution:
XPath 1.0 as available natively in VB.NET can't return the sequence of atomic numbers you describe, it can only return a single value or a nodeset. If, however, you were using VB.NET with an XPath 2.0 processor (such as Saxon.NET) you could simply use:
for $rocksong in /music_songs/song[category = 'Rock'] return $rocksong/count(preceding-sibling::song) + 1
Going back to XPath 1.0: you would first need to iterate through all the returned song elements returned by your expression and then, using another expression, evaluate the current song node position relative to previous song nodes:
count(./preceding-sibling::song)
I've shown below sample code of how you would use the .NET XPathNavigator to work with the context node in this case. This sample is in C# but should be easy enough to convert to VB.Net.
XPathDocument xdoc = new XPathDocument("c:\\test\\songs.xml");
XPathNavigator xnav = xdoc.CreateNavigator();
XPathExpression songsExpr = xnav.Compile("/music_songs/song[category='Rock']"); XPathExpression countSongsExpr = xnav.Compile("count(./preceding-sibling::song)");
XPathNodeIterator iterator = (XPathNodeIterator)xnav.Evaluate(songsExpr);
while(iterator.MoveNext()) { XPathNavigator songNav = (XPathNavigator)iterator.Current.Clone(); double songPosition = (double)songNav.Evaluate(countSongsExpr) + 1; }
The above XPath 1.0 sample works, but hopefully this also shows how much simpler (and more readable) things would be with XPath 2.0
Regards Phil Fearon http://qutoric.com/
On Sun, Jun 13, 2010 at 8:43 PM, Alice Wei<elite.english@xxxxxxxxx> 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.
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
1 2 3
for the index id of the search list. Is there a particular expression I need to use here?
Thanks for your help.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Find the Position Index o, Alice Wei | Thread | Re: [xsl] Find the Position Index o, Alice Wei |
Re: [xsl] extension/external functi, Michael Kay | Date | Re: [xsl] Find the Position Index o, Alice Wei |
Month |