Rails - Sep 2006 - options_from_collection_for_select

I''ve looked at the API on this but can''t quite see what
I''m missing from my call

<select id="pay[pay_id] name="pay[pay_id]">
  <%= options_from_collection_for_select(
   Pay.find_all_by_name, "id", "name") %> #<- line 5
</select>

is returning -
 Showing app/views/kr/index.rhtml where line #5 raised:

wrong number of bind variables (0 for 1) in: pays.`name` IS ?

Anyone ?

TIA
Stuart

--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

> wrong number of bind variables (0 for 1) in: pays.`name` IS ?
> 
> Anyone ?
This is because you haven''t specified an argument in your
''find_all_by''
query - it is expecting Pay.find_all_by_name("my name").

What I expect you''re trying to do is either just find all the records:

Pay.find(:all)

Or find all the pay records but only select the name and id:

Pay.find(:all, :select => "id, name")

Hope that helps,

Steve

--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---