FYI: I kinda of get the concept of eager loading and thought it would be better than the alternative... is there something else I need to do in order to get eager loading to work?
On Sep 28, 3:46 pm, Jason Fleetwood-Boldt <[email protected]> wrote: > On Sep 28, 2011, at 3:28 PM, ERB wrote: > > > I have two models, users and companies as indicated below. The users > > table has a foreign_key "company_id". > > > class User < ActiveRecord::Base > > has_many :companies > > end > > > class Company < ActiveRecord::Base > > belongs_to: user > > this should be > > belong_to :user > > > end > > > In my controller: > > > @user = User.where(:id => params[:id]).includes(:companies) > > > I get the following error: > > SQlite3::SQLException: no such column: companies.user_id: SELECT > > "companies".* FROM "companies" WHERE "companies"."user_id" IN ('8') > > Did you create a migration and run rake db:migrate ? > > > Why is RAILS getting the foreign key wrong and why is it trying to > > pull columns in the users table into the companies model? > > > -- > > Because you used .includes it is trying to eager load the companies. If you > don't know what eager loading is, you don't need it right now. One day you > will learn what eager loading is and you will then learn to use it, but until > that day you can get by without it. > > If you do know what eager loading is and your intention was to use it here, > that's a different matter. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
