store activerecords value in rails

5 views
Skip to first unread message

amruby

unread,
Jun 28, 2012, 11:11:32 AM6/28/12
to rubyonra...@googlegroups.com

i have one  query 
@recommendations = Cname.select("cnames.name,max(recommendations.count) as rcount").
                 where('recommendations.skill= ?',@key).
                 order('recommendations.company_id ASC').
                 group('recommendations.company_id,cnames.name').
                 joins('JOIN recommendations ON cnames.id = recommendations.company_id')

Here this query working in a loop, and this @key in where clause will change depend on the  loop,. how to store the each query results, because i need to get that @recommendations.name and @recommendations.rcount   results in view?

Thanks
Reply all
Reply to author
Forward
0 new messages