I have this statement in my application
User.all(:conditions => "status <> 3", :order => "firstname, lastname").collect{|x| [x.name, x.id.to_s]}
where I am trying to find all the users and sort them by first name and last name.
When I try using this statement it gives me the error
wrong number of arguments (given 1, expected 0).
Can anyone please help me with this?
Another way to write this
User.where('status <> 3').order(:firstname, :lastname).pluck(:name, :id)
The only difference is that the id won't be converted to a string so you can just append .map { |res| res[1] = res[1].to_s; res } if you really need this.
options = User.where('status <> 3').order(:firstname, :lastname).collect{|x| [x.name, x.id.to_s]}worked...
pluck can potentially perform better. If you use collect it means that you instantiate all ActiveRecord objects, while pluck will return a more "lightweight" array. I think the documentation puts it nicely. "Use pluck as a shortcut to select one or more attributes without loading a bunch of records just to grab the attributes you want."
codedef user_options options = User.all(:conditions => "status <> 3", :order => "firstname, lastname").collect{|x| [x.name, x.id.to_s]} endoptions = User.all(:conditions => "status <> 3", :order => "firstname, lastname").collect{|x| [x.name, x.id.to_s]}