MySQL 5 SP question: can I use parameter in LIMIT clause?

[Jason Chan]

I want to write a sp return paging of recordset.

CREATE PROCEDURE `sp_GetJobsDetails`(Page INT, PageSize INT)
BEGIN
     DECLARE RecordBegin INT;
     DECLARE tmpPageSize INT;
     SET RecordBegin = Page * PageSize - PageSize;
     SET tmpPageSize = PageSize + 1;

     SELECT           JOB_ID
     FROM         JOB
     LIMIT RecordBegin, tmpPageSize;  <- this line cause error, does it 
supported?

END 




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]