When I try to use @user.id I get the following error "Called id for nil, which would mistakenly be 4 -- if you really wanted the id of nil, use object_id"
Is there something else I would have to change in order for it to work without the object_id ? On Tue, Nov 10, 2009 at 2:28 AM, Bryan Larsen <[email protected]>wrote: > > Yes, the SQL NULL semantics have definitely burned me in the past. > You'd think that NULL would be != to an integer, but that's not > necessarily the case. As you've figured out, "IS NULL" and "IS NOT > NULL" work better. > > I don't think you want to use object_id here -- that's the internal ruby > identify. id is the SQL unique id. > > Bryan > > > christian wrote: > > That is a very clever suggestion. I have been wasting way too much time > > reloading pages today. > > > > I figured the entire thing out and this is what I came up with: > > > > @prose = Submission.find(:all, :include => :comments, :conditions => > > ["genre_id = ? AND (comments.owner_id != ? OR comments.submission_id IS > > NULL)", 1, @user.object_id]) > > > > If there are any clever suggestions on how to improve them feel free to > > share. > > > > I think I was getting it before but forgot that I would need an or > > statement to check for null. > > > > Thanks for everyone's patience. > > > > On Tue, Nov 10, 2009 at 2:13 AM, Bryan Larsen <[email protected] > > <mailto:[email protected]>> wrote: > > > > > > christian wrote: > > > I combined the two using this; > > > > > > @prose = Submission.find(:all, :include => [:comments, :genre], > > > :conditions => ["genres.name <http://genres.name> > > <http://genres.name> = ? and > > > comments.owner_id != ?", "Prose", "@user.comments"]) > > > > are you looking for comments.owner_id !=?", "Prose", @user.id > > <http://user.id>) > > > > The easiest way to figure stuff like this is to use script/console > > rather than constantly reloading web pages, IMO. > > > > Bryan > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Hobo Users" 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/hobousers?hl=en -~----------~----~----~----~------~----~------~--~---
