>I'm not sure about MySQL, but in Oracle you can do this easily,
>assuming I am understanding correctly what you need, maybe a
>similar solution is available for MySQL?
>
><CFQUERY Name="GetDays" Datasource="#DSN#">
>Select WS_WeekDay
>from weeklyschedule
>order by
> case
> when WS_WeekDay eq 'Sunday' then 1
> when WS_WeekDay eq 'Monday' then 2
> when WS_WeekDay eq 'Tuesday' then 3
> when WS_WeekDay eq 'Wednesday' then 4
> when WS_WeekDay eq 'Thursday' then 5
> when WS_WeekDay eq 'Friday' then 6
> when WS_WeekDay eq 'Saturday' then 7
> end case
></CFQUERY>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
