do a join to get both.
John
-----Original Message-----
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 5:03 PM
To: CF-Talk
Subject: RE: How to order by days of the week, but not alphabetically in
this query
I actually considered that, but see my solution message and I think it
works easier...
Rick
-----Original Message-----
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 4:49 PM
To: CF-Talk
Subject: RE: How to order by days of the week, but not alphabetically
in this query
> it requires a date value...this is just a string...Monday,
> Tuesday, etc.
>
> Is there a way to use this that I'm missing?
>
> > <CFQUERY Name="GetDays" Datasource="#DSN#">
> >
> > Select WS_WeekDay
> > from weeklyschedule
> > group by WS_WeekDay
> > order by WS_WeekDay
> >
> > </CFQUERY>
This might sound "cheesy", but how about making a new table with the
name of the day and a sort order
Then use an INNER JOIN and order by the day-order field
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
