haven't you just posted about this? or is this an example of a duplicate not being removed? :-)
--nahum On Aug 25, 11:03 am, Richard Hulse <[email protected]> wrote: > 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.
