Ruby on Rails

Hi, my first question, and probably a newbish one:

So I have a projects model, which belongs to a user :through an
assignment table...

like this:

class User
has_many :assignments
has_many :projects, :through => :assignments
end

class Project
has_many :assignments
has_many :users, :through => :assignments
end

class Assignment
belongs_to :user
belongs_to :project
end

Now I want in the startpage (home controller), after logging in, see
all the projects assigned to the current user.

How do I wwrite that query?

I have assignments like

@assignments = Assignment.where("user_id = ?", current_user.id)

but if I try the same thing with projects I get an error.... as there
is no user_id column in projects..

there must be an elegant way to query this with Active Record, right?

thanks in advance

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.