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 -~----------~----~----~----~------~----~------~--~---
