Re: LIMIT OFFSET with parameters?

[Ran Biron]

I've found a workaround for this problem.
It's ugly, time consuming and... mainly ugly. But it's working.

------SQL--------
DELIMITER $
CREATE PROCEDURE `tmp`()
BEGIN
PREPARE STMT FROM "SELECT * FROM users LIMIT ?,?";
END$
DELIMITER;

SET @a=2;
SET @b=1;

CALL tmp();
EXECUTE STMT USING @a, @b;
------SQL--------

It's tested to be working on 5.0.15.
Hope if helps anyone.

-----EDIT----------
Yet another method, this time not even breaking the SP barrier (security purposes):

....(inside SP)...
SET @String1 = concat(concat(concat(concat("SELECT field1,field2 FROM table1 WHERE field3 = ",sp_var1," && field4 = "),sp_var2," LIMIT "),sp_Var_skip,","),sp_var_count);
PREPARE Stmt FROM @String1;
EXECUTE Stmt;
SET @String1 = ""
......



Edited 1 time(s). Last edit at 12/26/2005 05:31PM by Ran Biron.