Group and count in Rails

Question

I have this bit of code and I get an empty object.

@results = PollRoles.find(
      :all, 
       :select => 'option_id, count(*) count', 
       :group => 'option_id', 
       :conditions => ["poll_id = ?", @poll.id])

Is this the correct way of writing the query? I want a collection of records that have an option id and the number of times that option id is found in the PollRoles model.

EDIT: This is how I''m iterating through the results:

<% @results.each do |result| %>
      <% @option = Option.find_by_id(result.option_id) %>
      <%= @option.question %> <%= result.count %>
     <% end %>

Answer 1

you want to use this function to do things like this
PollRoles.count(:all, :group => 'option_id') should return a hash mapping every option_id with the number of records that matched it

Answer 2

What do you get with this:

PollRoles.find(:all,:conditions=>["poll_id = ?",@poll.id]).collect{|p| p.option_id}