>Don't you need to DECLARE the variable "mvalidate" before you can
It's declared as OUT mvalidate varchar(10).
madderla sreedhar <email@example.com> 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))
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'
mvalidate := 'FALSE';
Any help is welcome .
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Don't you need to DECLARE the variable "mvalidate" before you can use it?
You already declare rowexists, try adding another declare.
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