List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 2 2005 2:47pm
Subject:Re: NEED HELP IN IF STATEMENT
View as plain text  
Shawn, Madderla,

 >Don't you need to DECLARE the variable "mvalidate" before you can use it?

It's declared as OUT mvalidate varchar(10).

PB

-----

SGreen@stripped wrote:

>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
>
>
>
>
>
>
>  
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 5/2/2005
>  
>

Attachment: [text/html]
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 5/2/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