hi
maybe its a simple question, but i can''t understand how to resolve it.
i have a model user and contact.
so a user can have many contact and contact belong to one user.
so for now i want count the number of contact of the user.
what i did is like this:
count = ActiveRecord::Base.connection.select_one("select
count(person_id) amis from contacts where user_id =" + user.id.to_s)
but i dont like this solutions cause the number of freind i will use
it in a sortable table, and if this variable dont belong to the user
params, i cant use it to sort the table :/
thanks.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, In the controller, get the user in question, for example @user = User.find(params[:id]) and then do count = @user.contacts.count Wael On May 25, 2011, at 2:23 PM, Adel Mediouni wrote:> hi > maybe its a simple question, but i can''t understand how to resolve it. > i have a model user and contact. > so a user can have many contact and contact belong to one user. > so for now i want count the number of contact of the user. > what i did is like this: > count = ActiveRecord::Base.connection.select_one("select > count(person_id) amis from contacts where user_id =" + user.id.to_s) > > but i dont like this solutions cause the number of freind i will use > it in a sortable table, and if this variable dont belong to the user > params, i cant use it to sort the table :/ > thanks. > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >-----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org iEYEARECAAYFAk3c9zwACgkQVWU5RcjdGKLcpwCdEm70lLXwvWvPOgm7CWgqISlY gugAoPplH3jIwb/xX9D7mRa/x/dJzuYT =QFh9 -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
thanks Wael :) it make the half of work. the probleme now is when i use the gems handles_sortable_columns i can''t sort the table with the count column cause the count field dont figure in the user table :S i didn''t find a solution !! On May 25, 2:34 pm, Wael Nasreddine <wael.nasredd...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > > In the controller, get the user in question, for example > > @user = User.find(params[:id]) > > and then do > > count = @user.contacts.count > > Wael > > On May 25, 2011, at 2:23 PM, Adel Mediouni wrote: > > > > > > > > > > > hi > > maybe its a simple question, but i can''t understand how to resolve it. > > i have a model user and contact. > > so a user can have many contact and contact belong to one user. > > so for now i want count the number of contact of the user. > > what i did is like this: > > count = ActiveRecord::Base.connection.select_one("select > > count(person_id) amis from contacts where user_id =" + user.id.to_s) > > > but i dont like this solutions cause the number of freind i will use > > it in a sortable table, and if this variable dont belong to the user > > params, i cant use it to sort the table :/ > > thanks. > > > -- > > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en. > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.17 (Darwin) > Comment: GPGTools -http://gpgtools.org > > iEYEARECAAYFAk3c9zwACgkQVWU5RcjdGKLcpwCdEm70lLXwvWvPOgm7CWgqISlY > gugAoPplH3jIwb/xX9D7mRa/x/dJzuYT > =QFh9 > -----END PGP SIGNATURE------- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hey Adel, I''m sorry I''ve never used this gem, but maybe try creating a count method on the user model. Wael On May 25, 2011, at 6:04 PM, Adel Mediouni wrote:> thanks Wael :) > it make the half of work. > the probleme now is when i use the gems handles_sortable_columns i > can''t sort the table with the count column cause the count field dont > figure in the user table :S > i didn''t find a solution !! > > On May 25, 2:34 pm, Wael Nasreddine <wael.nasredd...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Hello, >> >> In the controller, get the user in question, for example >> >> @user = User.find(params[:id]) >> >> and then do >> >> count = @user.contacts.count >> >> Wael >> >> On May 25, 2011, at 2:23 PM, Adel Mediouni wrote: >> >> >> >> >> >> >> >> >> >>> hi >>> maybe its a simple question, but i can''t understand how to resolve it. >>> i have a model user and contact. >>> so a user can have many contact and contact belong to one user. >>> so for now i want count the number of contact of the user. >>> what i did is like this: >>> count = ActiveRecord::Base.connection.select_one("select >>> count(person_id) amis from contacts where user_id =" + user.id.to_s) >> >>> but i dont like this solutions cause the number of freind i will use >>> it in a sortable table, and if this variable dont belong to the user >>> params, i cant use it to sort the table :/ >>> thanks. >> >>> -- >>> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. >>> To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en. >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG/MacGPG2 v2.0.17 (Darwin) >> Comment: GPGTools -http://gpgtools.org >> >> iEYEARECAAYFAk3c9zwACgkQVWU5RcjdGKLcpwCdEm70lLXwvWvPOgm7CWgqISlY >> gugAoPplH3jIwb/xX9D7mRa/x/dJzuYT >> =QFh9 >> -----END PGP SIGNATURE----- > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >-----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org iEYEARECAAYFAk3eSTIACgkQVWU5RcjdGKL+wwCfVTqAwT/eCd8G/Gs0nUTvkXS/ fDQAnRP4EjSDk8eIHEqA/uAyEiuJVRbF =pVEw -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.