Hi,
I want to display count of all records with particular field value from
database onto my view. How should I do that?
PLs tell me.
Thanx.
Prash
Hi,
I want to display count of all records with particular field value from
database onto my view. How should I do that?
PLs tell me.
Thanx.
Prash
I want to display count of all records with particular field value from
database onto my view. How should I do that?
I think you can do it as follows:
in yr controller:
@count = [model_to_be_queried].find(:all, [“field_name = ?”,
value]).size
and then use <%=h @count %> in your view
So for all records in your chicken table with 10 eggs
@count = Chicken.find(:all, [“eggs = ?”, 10]).size
If you only want the number of records it will be a lot faster to use
count rather than find as AR won’t have to instantiate all the
objects.
Person.count :conditions => [‘age = ?’, 29]
http://api.rubyonrails.org/classes/ActiveRecord/Calculations/ClassMethods.html#M000823
-Jonny.
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.
Sponsor our Newsletter | Privacy Policy | Terms of Service | Remote Ruby Jobs