Pagination

When using the pagination class, you can specify the :include
parameter. Is it possible to specify two for a table that references
two relations? For example a POST has both a USER and an
ORGANIZATION. Would the correct syntax be:

      @posts_pages, @posts = paginate(:posts,
        :include => :user,
                                :include => :organizations,
        :order => 'published_at DESC',
        :conditions => "organization_id=#{params[:organization_id].to_i}
AND published = true")

mindtonic@gmail.com wrote:

When using the pagination class, you can specify the :include
parameter. Is it possible to specify two for a table that references
two relations? For example a POST has both a USER and an
ORGANIZATION. Would the correct syntax be:

      @posts_pages, @posts = paginate(:posts,
        :include => :user,
                                :include => :organizations,
        :order => 'published_at DESC',
        :conditions => "organization_id=#{params[:organization_id].to_i}
AND published = true")

According to the API docs, paginate will pass the include options onto #find which in turn would expect an array, so:

  :include => [:user, :organisation]

is the way to do it.

Many Thanks