My has_many has many errors!

Rails
1

USER
has_many categories

CATEGORY
belongs_to user
has_many notes

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!

2

What is the error message given and the SQL generated (You can find
the SQL from the log)

-Zach

3

hi Zach,
Thanks for the reply…i found my careless error. there ww
a null value in my db that was causing the error!

4

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,

-Michael
http://javathehutt.blogspot.com