[Flask] SQLAlchemy + pagination + MySQL problems

Andrea D'Amore and.damore at gmail.com
Wed May 11 02:04:17 EDT 2016


On 11 May 2016 at 02:58, Scott Massey <scott.massey at gmail.com> wrote:
> [parameters: {u'param_1': -10, u'param_2': 10}]

> AS post_user_id \n FROM post ORDER BY post.publish_date DESC LIMIT -10, 10;

I see why the DBMS is annoyed at that -10. This is likely
Flask-SQLAlchemy specific, can you provide a minimal example?
I figure that inspecting a bit the Paginate instance would give you
some answer, and flask-sqlalchemy is a thin layer IIRC so shouldn't be
too hard to look around.


-- 
Andrea


More information about the Flask mailing list