Do I have to manually set a column in a dependent table for the id of the object to which it belongs? I have a collection of objects called photos that are owned by a analysis object. When I try to show an attribute of each of the photo objects I get this error: Mysql::Error: Unknown column ''photos.analysis_id'' in ''where clause'': SELECT * FROM `photos` WHERE (`photos`.analysis_id = 7) Extracted source (around line #1): 1: <% for photo in @analysis.photos %> 2: <p> 3: <%= photo.description %> 4: </p> -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
The normal rails convention is to use the table_id as the fk. You can over ride this in the model if need be. So if analysis :has_many => :photos the photo table would have a column analysis_id. On Mar 30, 11:49 am, ES <emsto...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Do I have to manually set a column in a dependent table for the id of > the object to which it belongs? > > I have a collection of objects called photos that are owned by a > analysis object. When I try to show an attribute of each of the photo > objects I get this error: > > Mysql::Error: Unknown column ''photos.analysis_id'' in ''where clause'': > SELECT * FROM `photos` WHERE (`photos`.analysis_id = 7) > > Extracted source (around line #1): > > 1: <% for photo in @analysis.photos %> > 2: <p> > 3: <%= photo.description %> > 4: </p>-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
got it, thanks! On Mar 30, 6:57 pm, Me <chabg...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> The normal rails convention is to use the table_id as the fk. You can > over ride this in the model if need be. > > So if analysis :has_many => :photos > > the photo table would have a column analysis_id. > > On Mar 30, 11:49 am, ES <emsto...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Do I have to manually set a column in a dependent table for the id of > > the object to which it belongs? > > > I have a collection of objects called photos that are owned by a > > analysis object. When I try to show an attribute of each of the photo > > objects I get this error: > > > Mysql::Error: Unknown column ''photos.analysis_id'' in ''where clause'': > > SELECT * FROM `photos` WHERE (`photos`.analysis_id = 7) > > > Extracted source (around line #1): > > > 1: <% for photo in @analysis.photos %> > > 2: <p> > > 3: <%= photo.description %> > > 4: </p>-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.