Urgent ActiveRecord has_many Problem - Please Help

Rails
1

Hi Guys,

I’ve been looking everywhere for an answer to this but so far without
success.

I have three models:

  1. employees
    has_many :memberships
    has_many :projects, :through => :membership

  2. projects
    has_many :memberships
    has_many :employees, :through => :membership

  3. membership
    belongs_to :employees
    belongs_to :projects

Membership is used to join employees to projects.

In my projects_controller I have a method called

def disassociate_employee(employee_id)
end

In this function I want to somehow delete the database row in
membership that joins employees t o projects.

I have no idea how to do this and has so far spend two full days
trying to figure this out, but starting to go a bit crazy trying to
figure this one out. :slight_smile:

Thanks for your help!!

2

On 4/21/08, codex1 [email protected] wrote:

  1. membership
    In this function I want to somehow delete the database row in
    membership that joins employees t o projects.

I have no idea how to do this and has so far spend two full days
trying to figure this out, but starting to go a bit crazy trying to
figure this one out. :slight_smile:

Membership.find_by_employee_id_and_project_id( employee_id, project_id
).destroy rescue nil

Or rewrite the find to use :conditions if you don’t trust the source
of your employee and project ids.

–
Greg D.
http://destiney.com/