nil in ActiveRecord and SQL

rubyonrails-talk
#1

In SQL, you need "something IS NULL" rather than "something = NULL".
The above code should have raised a StatementInvalid exception saying
as much.

Pass conditions as a hash to have Active Record choose whether to use
IS NULL for you:
  SomethingClass.find(:all, :conditions => { :something_attribute => nil })

Or use the find_all_by_* shorthand:
  SomethingClass.find_all_by_something_attribute(nil)

jeremy

#2

Check out the ez_where plugin if you'd like to easily translate Ruby's
operators to SQL.

jeremy