Can u please execute the following procedure in MySql and tell me where I had gone wrong because on my system the same code is giving error near line " := 'TRUE' "
CREATE PROCEDURE cart_items_validate (IN mcustid INT ,IN mprodid varchar(10), OUT mvalidate varchar(10)) BEGIN DECLARE rowexists INT(6); select count(*) into rowexists from esr_cartitems_data where customer_id=mcustid and item_id=mprodid; if rowexists>0 THEN mvalidate := 'TRUE' else mvalidate := 'FALSE'; end if; END; Any help is welcome . Thanks, Sreedhar. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
