On Sep 17, 12:08 am, surge <[EMAIL PROTECTED]> wrote: > Good points... > > > :select => "*, COUNT(...) AS issue_count" > > Aha! Now, that's exactly what I was looking for! I will just need to > add a "group by". > > > Although there's a caveat with the :select approach: AFAIK, MySQL 4.1 > > does not support subqueries, > > 4.1. supports subqueries, but why would I need them in this case? > Isn't it just an aggregate function?
Ah yes, I've totally forgotten about the GROUP BY. That'll work perfectly. --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
