|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
What is wrong with this SYNTAX?
From: Alex Katebi (alex.katebi
gmail.com)
Date: Tue May 19 2009 - 09:33:22 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
It is complaining about near STRCMP.
CREATE TRIGGER bgp.tglobal BEFORE UPDATE on bgp.global
FOR EACH ROW BEGIN
IF STRCMP(NEW.Variable_name,'ASN') != 0 THEN
set NEW.Variable_name=NULL;
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Variable_name=NULL
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END
Thanks in advance!
Alex
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]