Forum: Ruby on Rails my has_many has many errors!

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
mixplate (Guest)
on 2007-04-28 23:26
has_many categories

belongs_to user
has_many notes

belongs_to category

this is breaking..

@userCategories = Category.find(:all, :conditions => "user_id = 1",
:include => :notes)

yes, user_id is a column in my category table....thanks!
Zach M. (Guest)
on 2007-04-29 00:09
(Received via mailing list)
What is the error message given and the SQL generated (You can find
the SQL from the log)

mixplate (Guest)
on 2007-04-29 01:51
hi Zach,
Thanks for the reply...i found my careless error.  there ww
a null value in my db that was causing the error!
Michael K. (Guest)
on 2007-04-29 03:16
(Received via mailing list)
Hi there,

I'm actually wondering why you're finding the categories that belong
to a given
user in the manner that you've shown us. You've gone through all that
trouble to
define your user -> category relationship why not use it?

user = User.find(1)
@userCategories = user.categories

I see you're prefetching notes as well so you can add that to your
relationship declaration if
you really need them.

Anyway, not saying your usage isn't for good reason but given the
context it sorta jumps out
at me that you're not using the association for what's essentially
the same exact query as you're building by hand.

Best regards,

This topic is locked and can not be replied to.