Re: stored procedure LIMIT problem

[Dongkyu Kim]

You can use 'user variable' in stored procedure
to use your parameter.

For example, Andrew's code could be converted like this;

DELIMITER //

DROP PROCEDURE randomtest;//

CREATE PROCEDURE randomtest (mcode CHAR(5), ttle VARCHAR(30), lmt INT)
BEGIN

-- Set user variables!!!
SET @mcode = mcode;
SET @ttle = ttle;
SET @lmt = lmt;

PREPARE STMT FROM "SELECT distinct * FROM grp WHERE modulecode = ? AND grpcategory = ? ORDER BY RAND() LIMIT ?";
EXECUTE STMT USING @mcode, @ttle, @lmt;
END;
//

-------------------------------
Dongkyu Kim (superkdk at superkdk.com)