Ruby on Rails Thursday, June 28, 2012


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

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/q_eb4PrwhssJ.
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-US.

No comments:

Post a Comment