Sorting a collection in classic ASP

asp-classic, sorting

Solution

In this case I would get help from big brother .net. It's possible to use System.Collections.Sortedlist within your ASP app and get your key value pairs sorted.

set list = server.createObject("System.Collections.Sortedlist")
with list
  .add "something", "YY"
  .add "something else", "XX"
end with

for i = 0 to list.count - 1
    response.write(list.getKey(i) & " = " & list.getByIndex(i))
next

Btw if the following .net classes are available too:

- System.Collections.Queue

- System.Collections.Stack

- System.Collections.ArrayList

- System.Collections.SortedList

- System.Collections.Hashtable

- System.IO.StringWriter

- System.IO.MemoryStream;

Also see: Marvels of COM .NET interop

Problem

It's quite a simple question - how do I sort a collection? I've got a CSV file with rows in a random order. I'd like to sort the rows according to the date in one column. Do I add the rows to a recordset? Can I sort with a Scripting.Dictionary? I've clearly been spoilt with .NET and Linq, and now I find myself back in the land of classic asp, realising I must have known this 7 years ago, and missing generics immensely. I feel like a complete n00b.

Original source