Re: has many through associations

2006-09-02 Thread MrTufty
I'm pretty sure Cake doesn't support directly what Evan is looking for here, from what I've read. It's like an extension of HABTM which can handle (effectively) a 3-table join, without having to play around so much. You could probably achieve the same effect with the recursive parameter, but it

Re: has many through associations

2006-09-02 Thread [EMAIL PROTECTED]
I don't yet have a wide knowledge of all the possibilities in Cake, but I use an SQL VIEW to make multi-table joins easier. MySQL 5 supports SQL VIEWs. Creating the SQL VIEW is done in advance, from the MySQL command line or from any admin utility such as eskuel or phpmyadmin. A working example:

Re: has many through associations

2006-09-02 Thread nate
Cake 1.2 currently has limited support for 'through', but it is only functional for MySQL, and it only works for HABTM associations. There is no documentation on it, but it goes a little something like this: class Post extends AppModel { var $hasAndBelongsToMany = array(Author = array(with

Re: has many through associations

2006-09-01 Thread Evan
you misunderstand me. i am already too familiar with the four regular associations. what i'm looking for is a way of making associations THROUGH an intermediary association. read this in rails: http://wiki.rubyonrails.org/rails/pages/ThroughAssociations

Re: Re: has many through associations

2006-09-01 Thread Samuel DeVore
you mean like $this-ModelName-AssociatedModel-findAll($condition); You can do that On 9/1/06, Evan [EMAIL PROTECTED] wrote: you misunderstand me. i am already too familiar with the four regular associations. what i'm looking for is a way of making associations THROUGH an intermediary