so that all wendesdays have day (4) (assuming starting Sunday)?
tony
-----Original Message-----
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 3:21 PM
To: CF-Talk
Subject: How to order by days of the week, but not alphabetically in this
query
Hi, all...
How do I get this query to order by days of the week according to the
calendar, not alphabetically?
<CFQUERY Name="GetDays" Datasource="#DSN#">
Select WS_WeekDay
from weeklyschedule
group by WS_WeekDay
order by WS_WeekDay
</CFQUERY>
I tried order by DayofWeek(WS_WeekDay) as a guess, but that didn't work...
Rick
--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.224 / Virus Database: 261.9.8 - Release Date: 2/24/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
