Hi Jerry.
I'm new to the list, so don't take this as the final
answer. Wait for a guru to pounce with a better
solution!
But, here is my idea:
Before we start, note that "order" is a reserved word.
So we must backtick `order` to reference the table in
SQL (or the interpreter will think we're u
ds
> AND '2005-10-27 18:10' > starts;
>
> I have also seen this analysis stated more
> rigorously using Boolean
> Algebra. I don't have a link to it but it may be
> interesting for some of
> you if you took the time to go find it.
>
> Shawn Green
> Data
Hi C.F.
I'm new to the list, so please excuse me if I'm
answering out-of-turn from the pro's here.
I think the answer is to also check if the
BusyTime_start is between start and end of the
attempted scheduled.
ie:
WHERE
(TAID = 1) AND
(('2005-10-27 17:30' BETWEEN starts AND ends) OR
('2005-10
Hi.
Looks like the 'hosts' grant table is missing,
corrupt, or does not have permissions set correctly.
My examples come from version 4.1 I hope they apply,
or at least point you in the right direction.
My datadir is /var/lib/mysql - your's may be different
within the datadir there is another
