Hi Rolando,
Thanks for your help.
I have reduced the query to the bare essensials to try to test the concept,
but
it still fails...
( SELECT ID, Start, End
FROM site_calendar_v2 as c
WHERE Global='1' )
UNION
( SELECT '99999', '2006-11-01', '0000-00-00' as z )
ORDER BY z, Start ASC, Status DESC, Time ASC a
Does anyone see my mistake?
Keith
----- Original Message -----
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Keith Spiller" <[EMAIL PROTECTED]>
Cc: "MySQL" <mysql@lists.mysql.com>
Sent: Wednesday, November 01, 2006 2:11 PM
Subject: Re: Manually Inserted Data
The first UNION part has 19 columns
the other UNION part has 18 columns
----- Original Message -----
From: Keith Spiller <[EMAIL PROTECTED]>
To: [MySQL] <mysql@lists.mysql.com>
Sent: Wednesday, November 1, 2006 3:31:24 PM GMT-0500 US/Eastern
Subject: Manually Inserted Data
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
