Re: Please Help - Stored Procedure Issue

2006-06-28 Thread Jesse
" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 27, 2006 5:15 PM Subject: Re: Please Help - Stored Procedure Issue On Tuesday 27 June 2006 01:52 pm, Jesse wrote: @cInvNo replace all instances of this with just cInvNo. cInvNo is already declared as an OUT variable, and @cInvNo wi

Re: Please Help - Stored Procedure Issue

2006-06-27 Thread Chris White
On Tuesday 27 June 2006 01:52 pm, Jesse wrote: > @cInvNo replace all instances of this with just cInvNo. cInvNo is already declared as an OUT variable, and @cInvNo will be set to that value when you run: CALL sp_GetNextInv(-1,@cInvNo); -- Chris White PHP Programmer/DBBD Interfuel -- MySQL Gen

Please Help - Stored Procedure Issue

2006-06-27 Thread Jesse
I have the following stored procedure that I'm using: DELIMITER $$ DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$ CREATE PROCEDURE `sp_GetNextInv`( IN nChapterID Int, OUT cInvNo VarChar(7)) BEGIN Declare cPrefix VarChar(1); Declare cNextInv VarChar(7); Set cInvNo = ''; IF nChapterID > 0 THEN

help.....stored procedure

2005-02-17 Thread rajalakshmi s
Hi All, Im using MySQL 5.0 and my problem is I am not able to call a procedure more than once..Its working fine during 1st call..From the 2nd call onwards it vil give some error like "ERROR 1172 (42000): Result consisted of more than one row "IA sinilar problem can be found in "http://bugs.my