Re: What's wrong with this insert?
OK I'll ask again. I guess I need to leave out the separator line cause somebody can't understand it I guess. Seems lots of arrogance and cold blooded feedback but no (one) has an answer. What's wrong with this insert? Why does it have errors. Added the dumb delimiter for which you would think a semi colon would be the default. why doesn't Mysql have a clue. Should be pretty simple stuff. I can't imagine why Oracle releases such horrific poor quality egocentric documentation except to drive customers away from MySql. Is there no one on earth capable of providing a legitimate useful explaination for why this is magically invalid. I can look around the awful documentation and aparently that is why there is no answer. The docs have driven everyone mad. Here's the code again but i have tell you first, the ... is not part of the following code .....
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