Forum: Ruby on Rails has_and_belongs_to_many include problem

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
334ae822566107a2ea2b7a7cb88bd1d6?d=identicon&s=25 Brutyn Nick (Guest)
on 2006-01-03 10:48
(Received via mailing list)
hey,

i have users who are in groups, and i have a search form, where i can
search on
group, user lastname, and user firstname.
All this is also with pagination.

these are my models
class User < ActiveRecord::Base
has_and_belongs_to_many :groups
end
class Group < ActiveRecord::Base
    has_and_belongs_to_many :users
end

in my controller i do this
THIS works (but in need pagination)
@users2 = User.find_by_sql("select users.* from groups, users,
groups_users
where groups.id = " + @group_id.to_s + " and groups_users.group_id =
groups.id
and groups_users.user_id = users.id and users.last_name like '%" +
@last_name.to_s + "%' order by users.last_name ASC, users.first_name
ASC")

i get an error on this (can anyone help me???)
@user_pages, @users = paginate :user, :conditions => ['users.firm_id = ?
and
users.first_name like ? and users.last_name like ?', @firm_id,
"%#{@first_name}%", "%#{@last_name}%"] ,:include => [:groups], :order_by
=>
"users.last_name ASC, users.first_name ASC", :per_page => 10

private method `scan' called for #<Array:0x31da378>

RAILS_ROOT: ./script/../config/..
Application Trace | Framework Trace | Full Trace
active_record/associations.rb:964:in`include_eager_conditions?'
:952:in`construct_finder_sql_for_association_limiting'
active_record/associations.rb:946:in`select_limited_ids_list'
active_record/associations.rb:939:in`add_limited_ids_condition!'
:929:in`construct_finder_sql_with_included_associations'
active_record/associations.rb:917:in`select_all_rows'
active_record/associations.rb:830:in`find_with_associations'
active_record/base.rb:411:in`find'
action_controller/pagination.rb:174:in`find_collection_for_pagination'
action_controller/pagination.rb:192:in`paginator_and_collection_for'
action_controller/pagination.rb:124:in`paginate'

active_record/associations.rb:964:in`include_eager_conditions?'
952:in`construct_finder_sql_for_association_limiting'
active_record/associations.rb:946:in`select_limited_ids_list'
active_record/associations.rb:939:in`add_limited_ids_condition!'
:929:in`construct_finder_sql_with_included_associations'
active_record/associations.rb:917:in`select_all_rows'
active_record/associations.rb:830:in`find_with_associations'
active_record/base.rb:411:in`find'
action_controller/pagination.rb:174:in`find_collection_for_pagination'
action_controller/pagination.rb:192:in`paginator_and_collection_for'
action_controller/pagination.rb:124:in`paginate'
action_controller/base.rb:841:in`send'
action_controller/base.rb:841:in`perform_action_without_filters'
action_controller/filters.rb:332:in`perform_action_without_benchmark'
action_controller/benchmarking.rb:69:in`perform_action_without_rescue'
action_controller/benchmarking.rb:69:in`measure'
action_controller/benchmarking.rb:69:in`perform_action_without_rescue'
action_controller/rescue.rb:82:in`perform_action'
action_controller/base.rb:365:in`send'
This topic is locked and can not be replied to.