Re: [Rails] Sorting posts

2010-04-21 Thread Michael Pavling
On 21 April 2010 12:10, DanC wrote: > @topics = Topic.find(:all, :conditions => ["forum_id = ?", > @forum.id], :order => "total_replies DESC") > > but I get the error Mcolumn "total_replies" does not exist > > I know the column doesn't exist, but the question is, how can I get > the 'total_replies

Re: [Rails] Sorting posts

2010-04-21 Thread Juan José Vidal
I think that's you could use the counter_cache feature: class AddReplyCount < ActiveRecord::Migration def self.up add_column :topics, :replies_count, :integer, :default => 0 Project.reset_column_information Topic.find(:all).each do |t| t.update_attribute(:replies_count, t.repl

[Rails] Sorting posts

2010-04-21 Thread DanC
Hi, I have a topic model which has_many replies. On my topic index page I would like to be able to sort the topics by the number of replies. In my topic model I have defined Topic.rb ... has_many :replies def total_replies replies.count end And in my controller I have tried