I agree no real connection to the XML DB, unless you are having the DB apply the XSL to some XML.
Regardless, the answer for this situation is a simple order attribute on the sort node
<xsl:sort select="." order="descending"/>
That's all that is needed, which is exactly the same thing you'd do in an ORDER BY clause in SQL.
@_jum I am applying XSL to XML document using FOP 1.0 in order to generate PDF. I had already question regarding XSL sent here and got answer.
So should I rather use general XML channel?
@Jason_(A_Non) Regarding your suggested solution: <xsl:sort select="." order="descending"/>
In this case, by accident, it works but I am looking for something more general with any set of string to be able to replace them by 1, 2, 3 and order on the numbers rather then on the string. Something similar to oracle decode...
In fact I am not XSL expert I am just doing some minor changes to existing code.
Use your favorite search engine and search for
xsl sort by custom order
The solution from Rob DiNardo on his blog seems fairly short, but I didn't look deeply at all of them.
@Jason_(A_Non), Though the solution from Rob DiNardo might seem short as you said it worked for what I needed to do.
Thanks for your input.