Madderla,
1. Var assignments need SET, ie SET mvariable = ...
2. Missing semicolon after 'TRUE'
PB
-----
madderla sreedhar wrote:
>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
>
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005
