Can anyone tell me why this query is generating an ERROR:

DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes;

CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes` AFTER INSERT ON `rtsadven_development`.`content_assets`
FOR EACH ROW
BEGIN

IF NEW.content_asset_type_code = 'CURRI' THEN
INSERT INTO curriculums (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'COURS' THEN
INSERT INTO courses (content_asset_id) VALUES (NEW.id);
IF NEW.content_asset_type_code = 'DOC' THEN
INSERT INTO documents (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'MODUL' THEN
INSERT INTO modules (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TOPIC' THEN
INSERT INTO topics (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'WEBPG' THEN
INSERT INTO web_pages (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'EMAIL' THEN
INSERT INTO emails (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'FBPOST' THEN
INSERT INTO facebook_posts (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TWEET' THEN
INSERT INTO tweets (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'CHALL' THEN
INSERT INTO challenges (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'IMAGE' THEN
INSERT INTO images (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'VIDEO' THEN
INSERT INTO videos (content_asset_id) VALUES (NEW.id);
END IF;

INSERT INTO content_asset_statistics (content_asset_id, statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from content_asset_statistic_types where content_asset_type_code = NEW.content_asset_type_code;
=09
END;

Appreciate it.

Don Wieland


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql