Problem sorting RSS feed by date using XSL

Posted by Buckers on Stack Overflow See other posts from Stack Overflow or by Buckers
Published on 2009-02-16T22:50:58Z Indexed on 2010/05/08 19:08 UTC
Read the original article Hit count: 526

Filed under:

xsl

|

xslt

|

rss

|

datetime

|

sort

I'm creating a website where I need to show the top 5 records from an RSS feed, and these need to be sorted by date and time.

The date fields in the RSS feed are in the following format: "Mon, 16 Feb 2009 16:02:44 GMT"

I'm having big problems getting the records to sort correctly - I've tried lots of different code examples I've seen, but none seem to sort the records correctly. The code for my XSL sheet is shown below, and the feed in question is here.

Very grateful for anyones help!!!

Thanks,

Chris.

XSL CODE:

<xsl:stylesheet version="1.1" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:digg="http://digg.com//docs/diggrss/"
xmlns:dc="http://purl.org/dc/elements/1.1/">
<xsl:template match="/">	
<xsl:for-each select="//*[local-name()='item'][position() < 6]">	
	<p>
		<a>
		<xsl:attribute name="href">
		<xsl:value-of select="*[local-name()='link']"/></xsl:attribute>
		<xsl:attribute name="target">
		<xsl:text>top</xsl:text>
		</xsl:attribute>
		<xsl:value-of select="*[local-name()='title']"/>
		</a>
		<br/>
	<span class="smaller"><xsl:value-of select="*[local-name()='pubDate']" disable-output-escaping="yes"/></span>
	</p>
</xsl:for-each>

© Stack Overflow or respective owner

Related posts about xsl

Optimisation <xsl:apply-templates/> for a set of tags.

as seen on Stack Overflow - Search for 'Stack Overflow'
How it is possible to reduce this record? <xsl:template match="BR"> <br/> </xsl:template> <xsl:template match="B"> <strong><xsl:apply-templates /></strong> </xsl:template> <xsl:template match="STRONG"> <strong><xsl:apply-templates… >>> More
How do I set the encoding statement in the XML declaration when performing an XSL transformation usi

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a simple package installer in WinBatch that needs to update an XML file with information about the package contents. My first stab at it involved loading the file with Msxml2.DOMDocument, adding nodes and data as required, then saving the data back to disk. This worked well enough, except… >>> More
Using xsl:variable in a xsl:foreach select statment

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to iterate through an xml document using xsl:foreach but I need the select=" " to be dynamic so I'm using a variable as the source. Here's what I've tried: ... <xsl:template name="SetDataPath"> <xsl:param name="Type" /> <xsl:variable name="Path_1">/Rating/Path1/*</xsl:variable> … >>> More
xsl literal with <xsl:if>

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to write a very simple code in xsl: IF column=0 if result = .34 set background color to green and write $result, but if result = 0.10 set background color to white and write the word "QQQ" and what doesn't work is: <xsl:if test="$result = 0.35 and $column = 0"> <xsl:attribute… >>> More
XSL testing empty strings with <xsl:if> and sorting

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble with a template that has to check 3 different nodes and if they are not empty, print the data I am using for each node then doing the output but it is not printing anything. It is like the test returns zero. I have selected the parent node of each node i want to check the length… >>> More

Related posts about xslt

Why do XSLT editors insert tab or space characters into XSLT to format it?

as seen on Programmers - Search for 'Programmers'
All XSLT editors I've tried till now add tab or space characters to the XSLT to indent it for formatting. This is done even in places within the XSLT where these characters are significant to the XSLT processor. XSLT modified for formatting in this way can produce output very different to that of… >>> More
How to replace text defined in a given tag or element using xslt, xslt string replace

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, Please help me with this xslt transformation. Source Xml <xml> <test>This is a <bold>sample</bold> description. Please help me with a sample</text> </xml> Expected Output: This is a sample description. Please help me with a sample I just need to make… >>> More
C# and XSLT (using document() function in XSLT generates error)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to use embedded resources in my XSLT file, but while invoking 'document(...)' C# complains that "Error during loading document ..." I'd like to use defined resources in XSLT file and get them by this: "document('')//my:resources/"... How can i do that?? ex xsl: <?xml version="1.0"… >>> More
Turning XSLT into a simple HTML snippet.

as seen on Stack Overflow - Search for 'Stack Overflow'
http://drp.ly/yeAex <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/data/tour/entry"> <img src="{filename}"/> <h2>{heading}</h2> {description} </xsl:template> </xsl:stylesheet> Here… >>> More
JQuery > XSLT Plugin > Component returned failure code: 0x80600011 [nsIXSLTProcessorObsolete.transfo

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I'm using the XSLT plugin for JQuery, and here's my code: function AddPlotcardEventHandlers(){ // some code } function reportError(exception){ alert(exception.constructor.name + " Exception: " + ((exception.name) ? exception.name : "[unknown name]") + " - " + exception.message); } function… >>> More