Hi,
I am trying to get a list of unique items under the current scenario (Rails3):
A 'News' item:
has_many :categories, :through => :news_categories
I am getting a group of stories thus:
def self.news_feed_stories
joins(:news_categories).
where("news_categories.id != ?", Category.sport.id).
where("news_categories.id != ?", Category.top.id).
order('sort_order desc')
end
But there are duplicates when a story is in two categories.
I tried adding:
select("DISTINCT('news.*')").
but I get back no stories.
cheers,
Richard
--
You received this message because you are subscribed to the Google Groups
"WellRailed" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/wellrailed?hl=en.
