never mind, I sorted it out. Solution: named_scope :no_score, lambda { |compare| { :conditions => "#{compare} IS NULL" }}
On Nov 21, 10:12 pm, Ed <[EMAIL PROTECTED]> wrote: > How would I pass an attribute name into a named_scope lambda? > > I want to be able to search an active record class for nil values in a > particular attribute. Would like to use a named_scope instead of find > () because I want to tack other methods on the end of the result. > Syntax I've tried: > > # workouts table in mySQL: > # attributes time, reps, weight, distance > > class Workout < ActiveRecord::Base > named_scope :no_score, lambda {|compare| {:conditions => ["? IS NULL", > compare]}} # tried all these > named_scope :no_score, lambda {|compare| {:conditions => {compare => > nil }}} # forms of syntax > named_scope :no_score, lambda {|compare| {:conditions => > {compare.intern => nil }}} # with no success > > WorkoutController > @gym.workouts.no_score("time") > > Any ideas where I"m going wrong with the syntax? --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---