Re: What's wrong with this insert?
I'll keep trying - same problem only now with the additional problem of what's wrong with the set?
thanks
--------------------------------------------------------------
DELIMITER ;
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
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