On Sep 13, 4:16 pm, Jesse <[email protected]> wrote: > Hey Group, > > I am trying to use [what I thought should be] a simple scope for a > message object > > scope :unread, where(:read_at => nil) > > where the read_at attribute is of type datetime > > This is causing the scope to trip a no method error when called upon. > > I have a helper method which contains : > > if message.read_at == nil > "NEW" > end > > and that works fine. however even > > scope :unread, where("read_at == ?", nil ) >
When comparing with nil you have to use IS NULL rather than the usual comparison operator. where(:read_at => nil) should work though. How are you using the scope? Fred > does not seem to want to work. > > I know I must be missing something terribly obvious about this. Any kick > in the right direction is appreciated. > > Thanks > > Jesse -- 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.
