Hi,
I'm trying to manually insert data into a mysql query so that the
data will be sorted by the query but not inserted into the table.
Here's what I have so far:
( SELECT ID, Title, Label, Location, Start, End, Time,
Description, Organization, Department, Contact, Phone,
Email, Global, Board, Committee, Status,
TBD_Time , TO_DAYS(End) - TO_DAYS(Start) + 1 AS Days
FROM site_calendar WHERE Global='1' )
UNION
( SELECT '99999', 'No events exist for this month...', '', '', '',
'0000-00-00', '00:00:00', '', '', '', '', '', '', '1', '', '', '', '', as
z )
ORDER BY z, Start ASC, Status DESC, Time ASC
I just don't know what I am doing wrong her, or how to
accomplish this task. Please help.
Thanks,
Keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]