On Dec 3, 6:50 pm, phil <[EMAIL PROTECTED]> 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
>
> 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?
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
