Ok, I have a post model, and a comments model (Very similar to the
migrations screencast on the RoR website). I use a counter cache to
store the number of comments each post has with the post record.
I have just added Akismet anti-spam to my blog app, and am storing the
spam comments in the database until I have a change to manually verify
their spam-worthiness. The spam and non-spam comments are differentiated
by a boolean column called is_spam.
Thus I now want my counter_cache in the post model to only count those
comments that are NOT marked as spam (When a user clicks on a link that
says ‘5 comments’ only to discover there are none because they are all
spams, they are going to be slightly confused.
Any way I can achieve this?
Dougal - 3 weeks on Rails.