Cast the text strings to a date within your SQL query. Then, you can easily
sort by month.
-----Original Message-----
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: July 31, 2001 2:23 PM
To: CF-Talk
Subject: Sort by 1st three letters of month?
Ok, I'm an idiot. I have my users putting in text strings for months.
I need
Jan. 12
to be ordered ahead of
Aug. 9
These are text records. Is there any way to do this? I guess I could parse
out the first three characters of whatever my user entered, run it through a
big cfswitch to assign numerical values to the months, add a leading zero to
the day part...
Is there any easier way?
Willy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
