Stored routine does not work

[raydona]

Hi,
Could someone please let me know what is wrong with the following routine.

CREATE PROCEDURE ToVerifyEmployee(IN surname VARCHAR(15),IN email VARCHAR(40),OUT query INT)
BEGIN
DECLARE strA VARCHAR(15);
DECLARE strB VARCHAR(40);
SET strA = '';
SET strB = '';
SELECT LastName, EmailAddress
FROM Employee
INTO strA, strB
IF(strA = surname AND strB = email)
THEN SET query = 1;
ELSE SET query = 0;
END IF;
END;

I get the following error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3. I cannot find the error. Also I did not change the delimiter to something else than ; before declaring the procedure. I'll be grateful for all help.

[Weedpacket]

How are you sending this to the server? Maybe the client is cutting it short at the ';', thinking that it's a statement delimiter. (the only MySQL clients I have are PHP interfaces and I don't have the server, so I can't do any testing.)

Incidentally, wouldn't this be more convenient as a function?

[reli4nt]

Assuming this is mysql, it looks like the delimiter is the issue. I you look here: http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000297.html they discuss how to address the issue.

Never tried it myself so let us know if it pans out.