Has_many through combinations error


#1

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?


#2

On Dec 3, 6:50 pm, phil removed_email_address@domain.invalid 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


#3

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 C. removed_email_address@domain.invalid