RE: Stored Procedure problem

2008-02-15 Thread Rolando Edwards
x27; ? Give it a try !!! -Original Message- From: Barry [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 5:28 AM To: mysql@lists.mysql.com Subject: Stored Procedure problem Hello everyone! Hopefully somone can enlight me, i am hanging on this vor a few hours now :/ i have t

Stored Procedure problem

2008-02-15 Thread Barry
Hello everyone! Hopefully somone can enlight me, i am hanging on this vor a few hours now :/ i have this stored procedure: CREATE PROCEDURE additems () BEGIN DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21'; DECLARE newids VARCHAR(128); SELECT GROUP_CONCAT(a_id,newi

Re: Stored Procedure Problem

2006-03-10 Thread Josh
Peter, nice catch. Changing the parameter names did the trick. Thanks. --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Josh wrote: > > I posted this same item on the mysql forum but the > > only place that looked remotely appropriate was > under > > the Newbie section... I'm not sure if it will

Re: Stored Procedure Problem

2006-03-10 Thread Peter Brawley
Josh wrote: I posted this same item on the mysql forum but the only place that looked remotely appropriate was under the Newbie section... I'm not sure if it will be answer there so I thought I might toss it out here to see if there were any takers. I'm baffled as to why this stored procedure i

Stored Procedure Problem

2006-03-09 Thread Josh
I posted this same item on the mysql forum but the only place that looked remotely appropriate was under the Newbie section... I'm not sure if it will be answer there so I thought I might toss it out here to see if there were any takers. I'm baffled as to why this stored procedure is acting this