What's wrong with this insert?
So what is wrong with my simple Insert? I've tried to record it with the phpadmin and the mysqlworkbench and both don't like the way it end? "Unexpected end of input" expect ';' where the closing ) is?
thanks
--------------------------------------------------------------------
CREATE PROCEDURE `aspLogEntry` (
in p_le_let_id tinyint(1),
in p_le_msg varchar(2000),
in p_le_subject varchar(250),
in p_le_ipAddress varchar(150),
in p_le_host varchar(50),
in p_le_referrer varchar(150),
in p_le_UserAgent varchar(150),
in p_le_IsBot tinyint(1)
)
BEGIN
/* IF le_IsBot = null THEN
// set le_IsBot = 0;
//END IF; */
insert into tblLogEntry (
le_let_id,
le_msg,
le_subject,
le_ipAddress,
le_host,
le_referrer,
le_UserAgent,
le_IsBot
)
VALUES (
p_le_let_id,
p_le_msg,
p_le_subject,
p_le_ipAddress,
p_le_host,
p_le_referrer,
p_le_UserAgent,
p_le_IsBot
);
END
-----------------------------------------------------------------