# store activerecords value  in rails

**URL:** <https://discuss.rubyonrails.org/t/store-activerecords-value-in-rails/64332>\
**Category:** rubyonrails-talk\
**Created:** [June 28, 2012, 3:11pm UTC](https://discuss.rubyonrails.org/t/store-activerecords-value-in-rails/64332 "2012-06-28T15:11:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![amruby](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@amruby](https://discuss.rubyonrails.org/u/amruby)\
**Post date:** [June 28, 2012, 3:11pm UTC](https://discuss.rubyonrails.org/t/store-activerecords-value-in-rails/64332/1 "2012-06-28T15:11:32Z")

</div>

Thanks

i have one query @recommendations = Cname.select(“[cnames.name](http://cnames.name/),max(recommendations.count) as rcount”). where(‘recommendations.skill= ?’,@key). order(‘recommendations.company\_id ASC’). group(‘recommendations.company\_id,[cnames.name](http://cnames.name/)’). joins(‘JOIN recommendations ON [cnames.id](http://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?