Having problem creating function

[raydona]

Hi,

  I'm trying to create the following function:

 

DROP FUNCTION IF EXISTS VerifyAnEmployee;

DELIMITER |

CREATE FUNCTION VerifyAnEmployee(surname VARCHAR(15),email VARCHAR(40))

  RETURNS INT

  DETERMINISTIC

  READS SQL DATA

    BEGIN

      DECLARE query INT;

      DECLARE str1 VARCHAR(15);

      DECLARE str2 VARCHAR(40);

    SET str1 = '';

    SET str2 = '';

    SELECT LastName, EmailAddress INTO str1, str2

    FROM Employee

    WHERE LastName = surname AND EmailAddress = email;

  IF(str1 = surname AND str2 = email) THEN SET query = 1;

  ELSE SET query = 0;

  END IF;

RETURN query;

END;

|

  I get the following error:

#1419 - You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

  I don't know what the error means and how to resolve it. I would be grateful for all help.

[fenway]

Well, you don't have the SUPER privilege, apparently....