# acts\_as\_solr problem ActsAsSolr::SearchResults: **URL:** \ **Category:** rubyonrails-talk\ **Created:** [September 8, 2011, 1:04pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792 "2011-09-08T13:04:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Pab](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Pab](https://discuss.rubyonrails.org/u/Pab)\ **Post date:** [September 8, 2011, 1:04pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/1 "2011-09-08T13:04:43Z")
hi,      i am using acts\_as\_solr plugin when i tried with search    by    def search     puts "#####################"     # ids = params[:name]     @id = params[:query]     @emp = Employee.find\_by\_solr(@id)     puts "------------------------------#{@emp}"     respond\_to do |format|       format.html{render :action =\> 'search'}       format.xml     end   end in my model i gave acts\_as\_solr :fields =\> [:name] when i tried with search   puts "------------------------------#{@emp}" shows me the following      ------------------------------#\ any one say me how to retrive value to view page EMP id\<%= @emp.id %\>\ EMP Name\<%= @emp.name %\>\ in view error occurs as "undefined method `id' for nil:NilClass" thanks, -pab ---
**Author:** ![Tim\_Shaffer2](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@Tim\_Shaffer2](https://discuss.rubyonrails.org/u/Tim_Shaffer2)\ **Post date:** [September 8, 2011, 2:22pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/2 "2011-09-08T14:22:10Z")
As your example shows, when you do Employee.find\_by\_solr(@id) it does not return an Employee instance, but returns an instance of ActsAsSolr::SearchResults You will need to iterate through the results: results = Employee.find\_by\_solr(@id) results.each do |emp| puts emp.id end ---
**Author:** ![Pab](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Pab](https://discuss.rubyonrails.org/u/Pab)\ **Post date:** [September 8, 2011, 3:06pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/3 "2011-09-08T15:06:43Z")
hi, it shows following error NoMethodError (undefined method `each' for #\): thanks, -pab ---
**Author:** ![hassan](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/hassan/32/714_2.png) [@hassan](https://discuss.rubyonrails.org/u/hassan)\ **Post date:** [September 8, 2011, 3:15pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/4 "2011-09-08T15:15:54Z")
What did you find unclear about the doc for ActsAsSolr::SearchResults? ---
**Author:** ![Tim\_Shaffer2](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@Tim\_Shaffer2](https://discuss.rubyonrails.org/u/Tim_Shaffer2)\ **Post date:** [September 8, 2011, 3:28pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/5 "2011-09-08T15:28:00Z")
Looks like you might need to do results.results.each instead Check the docs: [http://code.paperplanes.de/acts\_as\_solr/rdoc/classes/ActsAsSolr/SearchResults.html](http://code.paperplanes.de/acts_as_solr/rdoc/classes/ActsAsSolr/SearchResults.html#M000032) ---
**Author:** ![Pab](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Pab](https://discuss.rubyonrails.org/u/Pab)\ **Post date:** [September 9, 2011, 6:28am UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/6 "2011-09-09T06:28:58Z")
hi, i am using [https://github.com/mattmatt/acts\_as\_solr](https://github.com/mattmatt/acts_as_solr) which contains no "each" method in acts\_as\_solr/libs/ search\_results.rb so for me each is not working with ActsAsSolr::SearchResults and i tried with [https://github.com/mauricio/acts\_as\_solr](https://github.com/mauricio/acts_as_solr) plugin wich results in following error "undefined method 'find\_by\_solr' for " can any one provide me solution for this thanks -pab ---
**Author:** ![Tim\_Shaffer2](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@Tim\_Shaffer2](https://discuss.rubyonrails.org/u/Tim_Shaffer2)\ **Post date:** [September 9, 2011, 11:46am UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/7 "2011-09-09T11:46:56Z")
Did you check the documentation I linked to? [http://code.paperplanes.de/acts\_as\_solr/rdoc/classes/ActsAsSolr/SearchResults.html](http://code.paperplanes.de/acts_as_solr/rdoc/classes/ActsAsSolr/SearchResults.html) Specifically, have a look at the records() results() or docs() methods. ---
**Author:** ![Pab](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Pab](https://discuss.rubyonrails.org/u/Pab)\ **Post date:** [September 9, 2011, 12:12pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/8 "2011-09-09T12:12:42Z")
hi,    i got data using this three and i got another doubt in table i have changed id as emp\_id, when i searched it it throws an error like Mysql::Error: Unknown column 'employees.id' in 'where clause': SELECT `employees`.\* FROM `employees` WHERE (employees.id in (NULL)) how can i over come this thanks, -pab ---
**Author:** ![Pab](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Pab](https://discuss.rubyonrails.org/u/Pab)\ **Post date:** [September 9, 2011, 12:15pm UTC](https://discuss.rubyonrails.org/t/acts-as-solr-problem-actsassolr/60792/9 "2011-09-09T12:15:15Z")
its searching for id where as i changed it as emp\_id is there any solution for this?