I can't seem to pass in the LIMIT clause variables into a stored procedure i.e.
Select * from table limit param1, param2; I get a syntax error compiling the procedure, but when I replace param1 and param2 with hard coded ints, ie, 10, 10, it compiles and works fine. Is this functionality not available? I had a similar problem w/ the Load Data Infile statement, in that it wouldn't allow me to pass in the file name as a parameter to the SPROC. If the LIMIT clause doesn't work this way either, I will really regret building the system using SPROCS, as most of the complicated queries will have to be hard-coded in PHP to allow variable passing on the query line, err! I hope I'm missing something. Thanks a lot for any help you can provide. Scott. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]