Paginate_by_sql giving errors

Hi,
I’m using paginate_by_sql to have pagination for my list views as my
queries have joins on multiple tables.
I have included the code into my application.rb , and in the controller
I have:

@discipline_pages, @disciplines = paginate_by_sql(Discipline,query,2)

But I get error as:

wrong number of arguments (4 for 2)

app/controllers/application.rb:63:in initialize' app/controllers/application.rb:63:innew’
app/controllers/application.rb:63:in paginate_by_sql' app/controllers/discipline_controller.rb:140:inlist’

At application.rb:63 I have:

object_pages = Paginator.new self, total, per_page,params[‘page’]

Please can someone help me with this…
Thanks in advance.

Hey,
I was able to solve the earlier error by changing application.rb:63 to:
object_pages = Paginator.new self, total, per_page,@params[‘page’]

But now I have another error which says…

You have a nil object when you didn’t expect it!
You might have expected an instance of ActiveRecord::Base.
The error occurred while evaluating nil.[]

app/controllers/application.rb:63:in paginate_by_sql' app/controllers/discipline_controller.rb:140:inlist’

Where am I going wrong…
Can someone please help…
Thanks.

Jeba M. wrote:

Hi,
I’m using paginate_by_sql to have pagination for my list views as my
queries have joins on multiple tables.
I have included the code into my application.rb , and in the controller
I have:

@discipline_pages, @disciplines = paginate_by_sql(Discipline,query,2)

But I get error as:

wrong number of arguments (4 for 2)

app/controllers/application.rb:63:in initialize' app/controllers/application.rb:63:innew’
app/controllers/application.rb:63:in paginate_by_sql' app/controllers/discipline_controller.rb:140:inlist’

At application.rb:63 I have:

object_pages = Paginator.new self, total, per_page,params[‘page’]

Please can someone help me with this…
Thanks in advance.