hi guys:
I'm not the sharpest tack in the box. I'm having
trouble making a trigger work.
CREATE TRIGGER update_calldate BEFORE INSERT ON
contacts
FOR EACH ROW
UPDATE contacts SET calldate="2006-08-15" where
calldate NOT IN ('2006-08-15')
;
The trigger accepts in so far as it creates the
trigger; but it doesn't perform the date update I want
it to perform.
Any suggestions? Thanks
-Chris
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
