Rails - Oct 2009 - Searching a model based on a filter on its association

Hi all,

I got association like the following in my rails app.
Class User < ActiveRecord::Base
  has_one :profile
end

Class Profile < ActiveRecord::Base
  establish_connection :some_other_db
  belongs_to :user
end

I need to search users based on the age stored in the profile
I tried using the :joins option of find. but it seems it works only on
tables in the same db.

Is there a way i can tell (:joins) to join a table from another db? Or is
there some other better way in which this could be achieved?

-- 
Sahil Dave

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Sahil Dave wrote:
> 
> I need to search users based on the age stored in the profile
> I tried using the :joins option of find. but it seems it works only on
> tables in the same db.
> 
But of course.

So search the Profiles, get your list of user_id''s that match the 
criteria, then select the Users.

-- 
Posted via http://www.ruby-forum.com/.