will_paginate appends more limits to already-limited sql
Reported by Adrian | May 29th, 2008 @ 05:51 PM
I have a SQL statement which UNIONs 4 SQLs together.
The SQL also contains a GROUP BY and an ORDER BY.
When clicking Next in the view page, end up with a SQL that ends:
LIMIT 0, 5 LIMIT 5, 5
and causes a failure.
Using MySQL
Rails 2.0.2
Mac OSX 10.4
Latest will_paginate gem (installed today).
Comments and changes to this ticket
-
Mislav May 29th, 2008 @ 07:25 PM
I'll have to see how you are making the call to will_paginate and how is it
integrated in the controller.
On Thu, May 29, 2008 at 5:52 PM, Lighthouse
wrote:
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Everyone's favorite Ruby library for pagination of practically anything!
Adrian
Mislav