madderla sreedhar <sreesind@stripped> wrote on 05/02/2005 03:10:07 AM:
> 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
>
Don't you need to DECLARE the variable "mvalidate" before you can use it?
You already declare rowexists, try adding another declare.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
