RE: Sort by 1st three letters of month?

2001-08-01 Thread Carlisle, Eric
Maybe ParseDateTime() would save you some time. -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 4: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 Ja

RE: Sort by 1st three letters of month?

2001-08-01 Thread Tangorre, Mike
. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 9:59 AM To: CF-Talk Subject: RE: Sort by 1st three letters of month? There is no need to do this in ColdFusion. Your database is able to convert the month numbers

RE: Sort by 1st three letters of month?

2001-08-01 Thread Kwang Suh
nd it works. Of course this calls for having seperate fields for month, day, date. Guy www.guymcdowell.com >-- > >Date: Wed, 01 Aug 2001 00:33:11 -0600 >From: "Kwang Suh" <[EMAIL PROTECTED]> >Subject: RE: Sort by 1st three letters

RE: Sort by 1st three letters of month?

2001-08-01 Thread Guy McDowell
this calls for having seperate fields for month, day, date. Guy www.guymcdowell.com >-- > >Date: Wed, 01 Aug 2001 00:33:11 -0600 >From: "Kwang Suh" <[EMAIL PROTECTED]> >Subject: RE: Sort by 1st three letters of month? >Message-ID:

RE: Sort by 1st three letters of month?

2001-08-01 Thread Kwang Suh
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 te

Re: [Sort by 1st three letters of month?]

2001-07-31 Thread Alex
you could set up an array,structure, or a new DB table with 1,jan .. 12 ,dec "Willy Ray" <[EMAIL PROTECTED]> wrote: 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 g