Wednesday, April 28, 2010
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 <lists@ruby-forum.com> wrote:
Dani Dani wrote:Thanks for the response - appreciated.
> 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
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-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@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-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment