Hi Ben, m_id = Materials.first(:conditions => "name == 'cardboard'")
Deck.all(:joins => 'inner join cards on cards.deck_id = cards.id', :conditions => ["(cards.name = 'Ace' OR cards.name = 'King') AND cards.material_id=?", m_id]) How about that ? On Wed, Apr 28, 2010 at 12:18, Ben Woodcroft <li...@ruby-forum.com> wrote: > Dani Dani wrote: > > Question. wouldn't the following do the work ? > > > > Card.find(:all, :conditions => "rank='Ace' or rank='King'" ).each do > > |card| > > decks << card > > > > or am I missing here something ? > > > > Dani > > Thanks for the response - appreciated. > > Well, I'm looking for a single query to be sent to the database. But > apart from that, as far as I see your solution adds the king and ace > cards to the decks, actually modifying the database, which I don't want. > > I simply want to query for all decks that already contain at least 1 > king and at least 1 ace, without using excessive amounts of SQL. > > Thanks, > ben > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-t...@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- Thanks & Regards, Dhruva Sagar. -- 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-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
