hi I amd tanizawa. I had problem. I can not get main.name value from below sql. "find_by_sql ''select main.id,main.name,sub.name from main left join sub on sub.id = main.id''" Please teach me how to get borth name value. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/_75fIh9qaQ4J. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en-US.
On 30 June 2012 10:08, tanizawa <kazuyat7175-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> hi > I amd tanizawa. > > I had problem. > I can not get main.name value from below sql. > "find_by_sql ''select main.id,main.name,sub.name from main left join sub on > sub.id = main.id''" > Please teach me how to get borth name value.My first question would be why are you using find_by_sql? Why not use the normal rails ActiveRecord methods. See http://guides.rubyonrails.org/active_record_querying.html and http://guides.rubyonrails.org/association_basics.html I assume you have already worked through the getting started guide and some tutorials such as railstutorial.org which is free to use online. Colin -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en-US.
I almost use normal ActiveRecord methods. I use find_by_sql for complected sql. 2012年6月30日土曜日 18時17分48秒 UTC+9 Colin Law:> > On 30 June 2012 10:08, tanizawa <kazuyat7175-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > hi > > I amd tanizawa. > > > > I had problem. > > I can not get main.name value from below sql. > > "find_by_sql ''select main.id,main.name,sub.name from main left join > sub on > > sub.id = main.id''" > > Please teach me how to get borth name value. > > My first question would be why are you using find_by_sql? Why not use > the normal rails ActiveRecord methods. See > http://guides.rubyonrails.org/active_record_querying.html > and > http://guides.rubyonrails.org/association_basics.html > > I assume you have already worked through the getting started guide and > some tutorials such as railstutorial.org which is free to use online. > > Colin >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/Y0cbAv-VbxAJ. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en-US.
On 30 June 2012 14:37, tanizawa <kazuyat7175-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I almost use normal ActiveRecord methods. > I use find_by_sql for complected sql.Why are you joining main.id on sub.id? Normally that would be considered poor database design. It would be usual to use a has_one belongs_to relationship, then you could use an ActiveRecord query. Also your table names should be plural to follow the Rails conventions. By the way, please don''t top post, it makes it difficult to follow the thread. Insert your reply inline. Thanks. Colin> > 2012年6月30日土曜日 18時17分48秒 UTC+9 Colin Law: >> >> On 30 June 2012 10:08, tanizawa <kazuyat7175-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> > hi >> > I amd tanizawa. >> > >> > I had problem. >> > I can not get main.name value from below sql. >> > "find_by_sql ''select main.id,main.name,sub.name from main left join >> > sub on >> > sub.id = main.id''" >> > Please teach me how to get borth name value. >> >> My first question would be why are you using find_by_sql? Why not use >> the normal rails ActiveRecord methods. See >> http://guides.rubyonrails.org/active_record_querying.html >> and >> http://guides.rubyonrails.org/association_basics.html >> >> I assume you have already worked through the getting started guide and >> some tutorials such as railstutorial.org which is free to use online. >> >> Colin > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/Y0cbAv-VbxAJ. > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en-US.-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en-US.
On Jun 30, 10:08 am, tanizawa <kazuyat7...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> hi > I amd tanizawa. > > I had problem. > I can not get main.name value from below sql. > "find_by_sql ''select main.id,main.name,sub.name from main left join sub > on sub.id = main.id''" > Please teach me how to get borth name value.Activerecord can''t tell the difference between the 2 name columns - you need to give them distinct names e.g. select main.id,main.name,sub.name as sub_name from main ... Fred -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@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-US.
Apparently Analagous Threads
- How do I access a child table/model from the parent in sql s
- Need help on Many to Many Relationships
- Rails 2 to Rails 3 - How to convert this sql query ?
- How do I destroy all the posts when the board is destroyed?
- rails 4, active record: appending to has_many :through does not create join model anymore?