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

The first UNION part has 19 columns
the other UNION part has 18 columns

----- Original Message -----
From: Keith Spiller <larentium@hosthive.com>
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/mysql?unsub=redwards@swmx.com

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" <redwards@swmx.com>
To: "Keith Spiller" <larentium@hosthive.com>
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 <larentium@hosthive.com>
> 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/mysql?unsub=redwards@swmx.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=l...m@hosthive.com