Hello guys!
I am new in rails.
I am querying the courses table for specific courses that belong to
specific institute using this sql statement. I''m getting the same
courses for all the institutes that I have. Any help on what to put in
place of 1 or how to restructure my query will be highly appreciated.
Here is my query!
<%= select ("course_code",
"course_name",Course.find_by_sql("select
i.name, c.course_name from institutes as i, courses as c ,
institute_courses as ic where i.id = ic.institute_id and c.id ic.course_id and
i.id = 1;").collect {|c| [ c.course_name, c.id ] })%>
--
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-/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.
