I have these classes: class FilmTitle < ActiveRecord::Base has_many :films_film_titles has_many :films, :through => :films_film_titles has_many :assets, :through => :films end class Film < ActiveRecord::Base has_many :assets end class FilmsFilmTitle < ActiveRecord::Base belongs_to :film belongs_to :film_title end class Asset < ActiveRecord::Base belongs_to :film end but this does not work: ft = FilmTitle.find 13 ft.assets <- throws error: ActiveRecord::StatementInvalid: Mysql::Error: Unknown column 'films.film_title_id' in 'where clause': SELECT `assets`.* FROM `assets` INNER JOIN films ON assets.film_id = films.id WHERE ((`films`.film_title_id = 13)) How can I get to these?
on 2008-12-03 19:51
on 2008-12-03 22:41
On Dec 3, 6:50 pm, phil <p...@philsmy.com> wrote: > I have these classes: > > class FilmTitle < ActiveRecord::Base > has_many :films_film_titles > has_many :films, :through => :films_film_titles > has_many :assets, :through => :films > end Last I heard, nested has many throughs like this weren't supported. Fred
on 2008-12-03 23:41
Well that's a drag. The SQL is easy... but I was hoping to make a named_scope. On Dec 3, 10:40 pm, Frederick Cheung <frederick.che...@gmail.com>