Yeah I deleted that post immediately after because that selects child.name. Something like :select => "mothers.name AS mother_name" would probably work, but just ugly AND then you'd need a mother_name virtual attribute in the Child model, making things rather needlessly horrific. I really can't think of a good way (without raw SQL) to do this in one query either.
On May 12, 3:33 pm, Colin Law <clan...@googlemail.com> wrote: > 2009/5/12 pharrington <xenogene...@gmail.com> > > > > > If you want to retrieve just the name, than use the :select option > > with your find: > > > @children = Child.find(:all, :include => :mother, :select => 'name') > > Does that select child.name or mother.name? > Colin > > > > > On May 12, 11:04 am, Colin Law <clan...@googlemail.com> wrote: > > > 2009/5/12 Anthony Ward <rails-mailing-l...@andreas-s.net> > > > > > Hi thank you > > > > > so if I use the include > > > > how do i just retrieve the name then > > > > Do you mean you want a query finding the child, including the > > > mother.namebut not the other mother fields? I do not know whether you > > > can do that. I > > > think the overhead of fetching all columns is going to be rather small. > > > Colin > > > > > example this is using the "magic way" > > > > > @children do |child| > > > > > ... print child.mother.name > > > > > end > > > > > -- > > > > 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@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 -~----------~----~----~----~------~----~------~--~---