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...@gmail.com> 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@googlegroups.com. > > To unsubscribe from this group, send email to > > rubyonrails-talk+unsubscr...@googlegroups.com. > > 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@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.