Hiii Active record --> mapping rec on table to object SO....
temp.first.inspect --> *user object* please try...... temp.first.content.inspect---> will show contents.id Note: first you must add relation between model user and model content.... Thank you On Mon, Oct 5, 2009 at 6:19 AM, PierreW <[email protected]> wrote: > > Hi guys, > > When I do: > > temp = User.find(:all, > :joins => "INNER JOIN contents ON users.agent_id = > contents.id", > :select => "contents.id, users.id, users.u_date") > > temp.first.inspect > > It seems to work fine, but it only returns: > #<User id: 6, u_date: "2009-10-03 19:32:23"> > > but not the contents.id information. > > I don't get it, and I don't know what to do to rectify this. It seems > like since I call find on User, it only returns infos related to this > model. > By the way, when I copy the SQL code generated by Rails directly in my > DB, it works fine and returns all 3 fields. > > Do you have any idea what I am missing? > > Thanks a lot! > Peter > > > -- Senior Rails Developer Anton Effendi - Wu You Duan --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
