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
;
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
Database Administrator
Unimin Corporation - Spruce Pine
Michael McFadden [EMAIL
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
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