Use data from multiple tables in one view.

rubyonrails-talk
1

Hey Matt, what’s the relationship or association between a ‘note’ and a ‘type’?

-Conrad

2

What does the model files look like?

-Conrad

3

class Note < ActiveRecord::Base   has_many :type end

class Type < ActiveRecord::Base   belongs_to :note end

4

You're making it harder than it needs to be, and I don't think you're understanding the relationships you are setting up.

Since a Note has many types, if you did this at the console:

note = Note.find :first

you would have a note. To list its types:

note.types

Since this is an array, you would have to find all the types this note had if you wanted to, say, display them. Something like:

note.types.each do |type|   puts type.type_name end

(in standard non-erb lingo)

If you were wanting to print all the types as you were trying to do in a view:

<% @notes.each do |note| %>   <% note.types.each do |type| %>     <%= h(type.type_name) %>   <% end %> <% end %>

Or, more simply:

<% @notes.each do |note| %>   <%= h(note.types.join(", ") %> <% end %>

I would consider getting rid of the name "type_name" and instead calling it "name". Also, you might want "has_many :types" rather than "has_many :type"

5

Thank you for your help with this. I knew I was looking into this and making it harder than it needed to be. It ended up that when I started second guessing myself I was troubleshooting the wrong issue.

I was getting nil values on some of my note types which was causing the error and this was because I put the column in after I had initially set up the database. Previous notes didn't have a type and thats where my problem was. I was looking at it that I had my relationship set up incorrectly and that I wasn't referencing it properly.