Dynamic SQL would work for Imbedding String for the IN clause.
That would be too messy for such a little query.
Here is a crazy suggestion
CREATE PROCEDURE additems ()
BEGIN
DECLARE grammatures VARCHAR(128) DEFAULT '7,12,1,13,2,5,14,21';
DECLARE newids VARCHAR(128);
SELECT
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
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 be