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!
on 2007-04-28 21:26
on 2007-04-28 22:09
What is the error message given and the SQL generated (You can find the SQL from the log) -Zach
on 2007-04-28 23: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!
on 2007-04-29 01:16
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