Hello-
I have two models (User and Locations). One user can have multiple
locations (home, office etc..) The location table has the lat and
lngs.
class User < ActiveRecord::Base
has_many :locations
acts_as_mappable :through => :locations
class Location < ActiveRecord::Base
belongs_to :user
acts_as_mappable
Now, when I do User.find_within(500. :origin => ..), It fails with the
following error:
Mysql::Error: Unknown column ''users.lat'' in
''field
list'':
So, it seems that the :through relationship is not working. Can
someone pelase help me.
thanks
-John
Dmitry Sokurenko
2009-Apr-22 09:17 UTC
Re: acts_as_mappable :through relationship is not working
John, acts_as_mappable is not an association, it''s a custom macro and it doesn''t support :through option. So remove it from the User model. And to find all users near some point use something like: Location.find_within(500. :origin => ..., :include => :user).map (&:user).uniq Dmitry