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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
