List:General Discussion« Previous MessageNext Message »
From:SGreen Date:May 2 2005 2:09pm
Subject:Re: NEED HELP IN IF STATEMENT
View as plain text  
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






Thread
NEED HELP IN IF STATEMENTmadderla sreedhar2 May
  • Re: NEED HELP IN IF STATEMENTSGreen2 May
    • Re: NEED HELP IN IF STATEMENTPeter Brawley2 May
  • Re: NEED HELP IN IF STATEMENTPeter Brawley2 May