XML order by Attribute

Question

I have googled around and tried to find an answer to this, but none of the solutions seem to work. I have the following xml schema:

<xml>
  <race>
    <particpant time="3.25" name="joe blogs">
    <particpant time="1.15" name="john Doe">
    <particpant time="2.0" name="A random">
  </race>
</xml>

I then attempt the following transformation in xslt:

<ul>
   <xsl:for-each select="participant">
   <xsl:sort  order="ascending" select="@time"/>
     <li> <xsl:value-of select="@name"/> (<xsl:value-of select="@time"/>)</li>
   </xsl:for-each>
 </ul>

The loop works and pulls out each participant, but the sort ordering has a weird effect, it switches positions around but not necessarily ordering them into the correct order.

Can anyone point me in the right direction.

BTW The code above is a stripped back version of my code and with dummy data as the actual file is larger and more complex.

Thanks in advance

John

Answer 1

I think that this might be because it is sorting values as though they were strings. Have you tried the following?

 <ul>
   <xsl:for-each select="participant">
   <xsl:sort data-type="number" order="ascending" select="@time"/>
     <li> <xsl:value-of select="@name"/> (<xsl:value-of select="@time"/>)</li>
   </xsl:for-each>
 </ul>