filter xml and sort xml

Hello everyone,

I am a newbie to xml and I urgently need help for the following.
Any help is greatly appreciated.


I have an xml which stores files uploaded, as follows:

<?xml version="1.0">
<files>
<file id="1" name="file.asp" lastupdated="3/2/06 09:20:29AM">
<file id="2" name="file.doc" lastupdated="3/2/06 11:30:45AM">
<file id="3" name="file.xml" lastupdated="3/2/06 10:40:30AM">
............
............
</files>

and in another html file,I have a few hyperlinks as follows:

last uploaded in
1 hour -> this is a hyperlink
2 hour -> this is a hyperlink
3 hour -> this is a hyperlink

upon clicking the hyperlink, I need to show files uploaded within the specific hour (clicked by user).

I understand that XSL may be required to do the sorting and filtering?
How do I go about working on it?

Besides displaying all the files uploaded within the specific hour.
How can I set such that only the last 10 are displayed only?

I am using ASP (VB) for coding.

Thank you.

Best Regards.

You can use the Micosoft XML library in ASP to work with XML (load XML, sort nodes etc.) or you could use XSL to transfor the XML but if you wish to sort / filter by dates then XSL might not be the best way as there are no internal functions for comparing dates.