[thelist] sorting recordset problems

Pringle, Ron RPringle at aurora-il.org
Wed Jan 4 16:29:36 CST 2006


Thanks for that, nice solution! I was going down a similar path when I
realized that the day portion of the file name wasn't written with leading
zeros in the case of a single digit day and decided the files needed to be
renamed for sanity's sake.

Your solution is what I originally had in mind though, so thanks for
fleshing it out! I'll store it away just in case.


> Ron,
> This is an interesting problem indeed. If the month is
> always characters 4 to 6 then I have a solution that
> will fix half of your problem. 
> Create a new table called something like
> month_id(month_name, id) and populate with values like
> month_name    id
> Jan           1
> Feb           2
> Mar           3
> Apr           4
> Now a SQL statement like the following will sort the
> files by month.
> SELECT d.crazydate
> FROM date_test d, month_id m
> WHERE m.month_name = RIGHT(LEFT(d.crazydate, 6), 3)
> ORDER BY m.id
> The date part could be solved with a similar approach
> I think. Will let you know if I figure it out.

More information about the thelist mailing list