arnor@icetips.com
Member
Hi all,
Is it possible to apply mySQL LIMIT to a list? We have a user query situation which might return too many rows to be practical so to limit traffic we'd like to set a limit to say 500 or 1000 rows. I've figured out with help from the forum, how I can construct the WHERE clause, but I can't see a way to plug a LIMIT clause in there. It needs to go AFTER the ORDER BY clause if there is one, so I don't think I can just tack it onto the WHERE clause. Is there a way to handle this via the PHP plugin?
Or is there a way in Fabrik to set the max number of rows?
Best regards,
Is it possible to apply mySQL LIMIT to a list? We have a user query situation which might return too many rows to be practical so to limit traffic we'd like to set a limit to say 500 or 1000 rows. I've figured out with help from the forum, how I can construct the WHERE clause, but I can't see a way to plug a LIMIT clause in there. It needs to go AFTER the ORDER BY clause if there is one, so I don't think I can just tack it onto the WHERE clause. Is there a way to handle this via the PHP plugin?
Or is there a way in Fabrik to set the max number of rows?
Best regards,