Subject: RE: [xsl] Q on <xsl:sort> From: "Clapham, Paul" <pclapham@xxxxxxxxxxxxx> Date: Tue, 1 May 2001 13:33:52 -0700 |
You told it to sort as if the data it was sorting was a number. So it takes '2001-04-16T04:30:32' and converts it to a number; what does this give? Probably NaN. So since all the data items being sorted are NaN, the sort has to fall back on document order, and since you asked for descending, you get reverse document order. PC2 -----Original Message----- From: Walter Torres [mailto:walter@xxxxxxxxx] Sent: May 1, 2001 13:08 To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] Q on <xsl:sort> I have this snippet... (see below) I have a four record sample set ( 1 record sample xml is below ). Each record is different date/times. My problem is that this sort is not sorting on what I thought it would. It should display... record 4 record 1 record 3 record 2 But it is... record 4 record 3 record 2 record 1 It looks like it is displaying in reverse xml order not reverse timestamp order. any ideas? Walter =========================================================== <xsl:template match='callEvent/response/interaction_list'> <xsl:apply-templates> <xsl:sort select='./interaction/timestamp' order='descending' data-type='number' /> </xsl:apply-templates> </xsl:template> <!-- timestamp NODE Template --> <xsl:template match="timestamp"> <!-- Pull the pieces apart --> <xsl:variable name='datetime' select='.' /> <xsl:variable name='year' select='substring( $datetime, 0 , 5 )' /> <xsl:variable name='month' select='substring( $datetime, 6 , 2 )' /> <xsl:variable name='day' select='substring( $datetime, 9 , 2 )' /> <td valign='top'> <!-- put the date together in American order --> <xsl:value-of select="concat($month, '/', $day, '/', $year )" /> <!-- Seperate the date and Time --> - <!-- Display the Time --> <xsl:value-of select='substring( $datetime, 12 , 9 )' /> </td> </xsl:template> =========================================================== -- sample record, 1 of 4 in my demo set -- -- the interaction NODE is repeated in this set -- <callEvent> <response> <interaction_list> <interaction id='19766'> <timestamp unix='987413416000'>2001-04-16T04:30:32</timestamp> <media_type id='103'>Phone</media_type> <channel id='1'>-</channel> <ani></ani> <dnis></dnis> <route_type>I</route_type> <events> <call_event id='34757'> <timestamp unix='987413416000'>2001-04-16T04:30:32</timestamp> <call_event_type id='98'>eMail</call_event_type> <customer id='2124'>Harris</customer> <curr_dest id='103'>Vincent</curr_dest > <to_dest id='1'>-</to_dest> <nav_code id='1'>-</nav_code> <rule id='1'>-</rule> <greeting id='1'>-</greeting> <call_type id='1'>-</call_type> <ext_call id='1'>-</ext_call> <old_call_record id='1'>-</old_call_record> <product id='1'>-</product> <reason id='198'>Case Resolution</reason> <detailed_comment>Closed issue about bad check</detailed_comment> </call_event> </events> </interaction> </interaction_list> </response> </callEvent> ===================================== eof XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Q on <xsl:sort>, Walter Torres | Thread | RE: [xsl] Q on <xsl:sort>, Walter Torres |
[xsl] Q on <xsl:sort>, Walter Torres | Date | [xsl] How does XSLT deal with inter, Frank Zhou |
Month |