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
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:
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
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
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