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@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.
