Pascal
> -----Original Message-----
> From: Jeff Waris [mailto:[EMAIL PROTECTED]
> Sent: woensdag 30 juni 2004 15:46
> To: CF-Talk
> Subject: Sorting help!
>
> Got a real odd sorting problem here, and I am kind of stumped....
>
> Using CFHTTP, I generate a file on the fly that contains some
> user information. It has three fields on each line,
> constituting 1 record. This file cannot be formatted any
> other way. I have no control over it. (Until it gets to me)
>
> the file is formatted like this
>
> 11111111,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,03-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,04-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,03-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 22222222,04-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
>
> Field one is an account number, field two is a date and the
> third field is an associated picture(uniquely named for each
> line) The dates may range over a year or two. the file is
> sorted by account number then by date ascending.
> I need to sort by account number then by date DESCENDING.
>
> I've tried to sort descending, by treating each line as a
> list item using listsort(). It almost works. For everything
> under a year, the list sort is fine, but anything with
> entries over 1 year for an account I would get this:
>
>
> 11111111,01-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,01-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2003,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,02-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,03-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
> 11111111,04-01-2004,xxxxxxxxxxxxxxxxxxx.jpg
>
> I was thinking of putting everything in array, but I don't
> think I will be able to sort them the way I want this way
> either. Is there a way to do this without database
> intervention? Any help would be greatly appreciated...
>
> Thanks!
> Jeff
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
