Ruby on Rails Saturday, June 30, 2012

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@gmail.com> 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@googlegroups.com.
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.

No comments:

Post a Comment