From: Gerald L. Clark <[EMAIL PROTECTED]>
To: Keith Spiller <[EMAIL PROTECTED]>
Cc: [MySQL]
Sent: Wednesday, November 1, 2006 4:51:21 PM GMT-0500 US/Eastern
Subject: Re: Manually Inserted Data
Keith Spiller wrote:
> Hi Rolando,
>
> Thanks for your help.
>
> I have reduce
Keith Spiller wrote:
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
( SELECT ID, Start, End as z
FROM site_calendar_v2 as c
WHERE Global='1' )
UNION
( SELECT '9', '2006-11-01',
27; 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"
Sent: Wednesday, November 01, 2006
The first UNION part has 19 columns
the other UNION part has 18 columns
- Original Message -
From: Keith Spiller <[EMAIL PROTECTED]>
To: [MySQL]
Sent: Wednesday, November 1, 2006 3:31:24 PM GMT-0500 US/Eastern
Subject: Manually Inserted Data
Hi,
I'm trying to manually inser
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