> I've been looking for a while and I can't find a way to compose an
> activerecord .where query that excludes certain ranges / values.
> 
> Like User.where(:id !=> [3,9,23], :active => 1)

User.where(["active = 1 AND id NOT IN (?)", [3,9,23]])

If it were me, I'd create a scope on User named 'active' so you could do...

User.active.where(["id NOT IN (?)", [3,9,23]])

You could even create a "not_in" scope if you wanted to, but that might be 
going a little too far...

-- 
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to