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

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