Jump to content
Larry Ullman's Book Forums

Error On Procedure Declaration


Recommended Posts

I am attempting to create a procedure based on add_to_cart(), but am getting a SQL Syntax error.

 

DELIMITER $$
CREATE PROCEDURE add_to_cart(uid CHAR(32), item_type VARCHAR(7), item_id MEDIUMINT, opt1 VARCHAR(32), opt2 VARCHAR(32), qty TINYINT)
BEGIN
  DECLARE cart_id INT;
  SELECT id INTO cart_id FROM carts WHERE user_session_id=uid AND item_type=item_type AND item_id=item_id AND option_1=opt1 AND option_2=opt2;
  IF cart_id > 0 THEN
    UPDATE carts SET quantity=quantity+qty, date_modified=NOW() WHERE id=cart_id;
  ELSE 
    INSERT INTO carts (user_session_id, item_type, item_id, option_1, option_2, quantity) VALUES (uid, item_type, item_id, opt1, opt2, qty);
  END IF;
END$$
DELIMITER ;

Clearly, I have added a few columns, but believe I am accounting for them correctly.  In reading the MySQL documentation, it recommends 'SELECT id INTO @cart_id...' and that, too, fails.  So I am at a loss as to where I am munging the syntax here.

Link to comment
Share on other sites

 Share

×
×
  • Create New...