Hi, if I do: user = User.find :all render :xml => user.to_xml I obviously get the user records whith ALL the columns (name, surname, tel, email, ...) How I can get just the column email (for example) ? ps. I wan''t to use User.find_by_sql(''Select mail from users'') thanks -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Apr 7, 10:54 am, Ale Ds <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Hi, > > if I do: > user = User.find :all > render :xml => user.to_xml > > I obviously get the user records whith ALL the columns (name, surname, > tel, email, ...) >depending on what you''re doing, either use the :select option on the call to find or the :only/:except options on to_xml may be what you want. Fred> How I can get just the column email (for example) ? > > ps. > > I wan''t to use User.find_by_sql(''Select mail from users'') > > thanks > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---
'':select'' is perfect: users = User.find(:all, :select = ''email'') I overlooked it in RoR api. Thank you ! Alessandro Frederick Cheung wrote:> On Apr 7, 10:54�am, Ale Ds <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: >> Hi, >> >> if I do: >> user = User.find :all >> render :xml => user.to_xml >> >> I obviously get the user records whith ALL the columns (name, surname, >> tel, email, ...) >> > > depending on what you''re doing, either use the :select option on the > call to find or the :only/:except options on to_xml may be what you > want. > > Fred-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---