From: Peter Brawley
Date: May 2 2005 2:27pm
Subject: Re: NEED HELP IN IF STATEMENT
List-Archive: http://lists.mysql.com/mysql/183495
Message-Id: <427638CC.7010809@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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