This mailinglist is for GitHub, if you have issues with a project hosted on Github you should contact the project's mailing list, issue tracker, or the project owner. Tekkub Github General Support http://support.github.com/ Join us on IRC: #github on freenode.net Discussion group: [email protected]
On Tue, Dec 23, 2008 at 9:52 AM, rubygroupie <[email protected]>wrote: > > The SQL being generated for each page is as follows: > > page 1 > SELECT * FROM (SELECT TOP 100 * FROM (SELECT TOP 100 * FROM > [transactions] ) AS tmp1 ) AS tmp2 > > page 2 > SELECT * FROM (SELECT TOP 100 * FROM (SELECT TOP 200 * FROM > [transactions] ) AS tmp1 ) AS tmp2 > > page 3 > SELECT * FROM (SELECT TOP 100 * FROM (SELECT TOP 300 * FROM > [transactions] ) AS tmp1 ) AS tmp2 > > Obviously, it keeps referencing the top 100 no matter what page link > you select. What's going on here? > > Model Code: > cattr_reader :per_page > @@per_page = 100 > > Controller Code: > @transactions = Transaction.paginate :page => params[:page], :order => > params[:sort] > > View Code: > <%= will_paginate @transactions %> > > I'm using: > rails - 2.1.0 (frozen) > will_paginate - 2.3.6 > SQL server > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "GitHub" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/github?hl=en -~----------~----~----~----~------~----~------~--~---
