Re: hasAndBelongsToMany with a join table with a datetime column

[Chris Lamb]

Hi Matt,

> However if I create a third model can I use that to order the results?

Sure you can :)

 class Member extends AppModel
        var $name = 'Member';
        var $hasMany = array('MemberTeam' => array(
                'className'   => 'MemberTeam',
                'order'       => 'MemberTeam.created'
        ));
 } 

 class Team extends AppModel { 
        var $name = 'Team';
        var $hasMany = array('MemberTeam' => array(
                'className'   => 'MemberTeam',
                'order'       => 'MemberTeam.created'
        ));
 } 

 class MemberTeam extends AppModel { 
        var $name = 'MemberTeam';
        var $hasOne = 'Member,Team';
 }


Cake should also fill in the 'created' field automatically for you.

Regards,

--lamby

-- 
 Chris Lamb, Cambridgeshire, UK             WWW: http://chris-lamb.co.uk
  Q. Why is top posting bad?                             GPG: 0x634F9A20
  A. Because it breaks the logical sequence of discussion

signature.asc
Description: PGP signature