NEED HELP IN IF STATEMENT

[madderla sreedhar]

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