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.

Reply via email to