this works for me:
@user = User.where(:id => params[:id] ).joins('LEFT JOIN companies
ON companies.id = users.company_id')
so then I guess its a question on understanding eager loading?
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.
