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 ----- [EMAIL PROTECTED] wrote: madderla sreedhar <[EMAIL PROTECTED]> 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.comDon'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 outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 5/2/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]