Ruby on Rails Friday, December 7, 2012


On Thursday, December 6, 2012 11:59:54 AM UTC, Ruby-Forum.com User wrote:


=====
 @monthly_data = ReviewRating.group("date_format(insertdate, '%Y/%m'),
type").count(:conditions => {:insertdate => '2011-01-01'..'2099-01-01'})

When you use the string form of group, rails doesn't look into the string to see that you are grouping on 2 different things.
I'd try group("date_format(insertdate, '%Y/%m')", "type")

Fred

--
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 rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/aP_c557v-2cJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment