[Rails] Joining three tables

On 7 February 2012 11:41, Tony N. wrote:
Hi I really need some help. I'm new on rails and I need to join three
tables in one view.

I have three models
class TypeEvent < ActiveRecord::Base
You want has_many :events here.
end
class Event < ActiveRecord::Base
belongs_to :type_event
belongs_to :computer
end

class Computer < ActiveRecord::Base
belongs_to :room
has_many :events, :dependent => :delete_all
end
The show action in the Computer controller is written like this :
def show
@computer = Computer.find(params[:id])
respond_to do |format|
format.html # show.html.erb
format.xml  { render :xml => @computer }
end
end
I would like to display the following fields in the show.html.erb view
type_events.name from the type_events table
events.information from the type_events table
events.state , events.created_at , envents.updated_at from the events
table

On Feb 7, 6:22 am, "Tony N." wrote:
Thanks I'll try it right now. Thank you for your help.

--
Posted viahttp://www.ruby-forum.com/.