yep you will need to develop your own HABTM behavior that will take care of that because john is right, in the default HABTM table, only the primary keys of the two joined tables are allowed something I regretted as well in the past but you can easily work around it - manually :)
On 17 Feb., 22:10, John Andersen <[email protected]> wrote: > I do think that you need to take a look at The Join Model in the > CakePHP book > at:http://book.cakephp.org/#!/view/1650/hasMany-through-The-Join-Model > > as what you want is to have additional data in your intersection table > and CakePHP normal usage does not allow that. > Whether or not it will be able to automatically populate the created > and modified columns is not something I am sure about though! > Enjoy, > John > > On Feb 17, 5:19 pm, rgreenphotodesign <[email protected]> > wrote: > > > > > > > > > Just for good measure here are my relationships in the models: > > > Activity: > > > var $hasAndBelongsToMany = array( > > 'Statustype' => array( > > 'className' => 'Statustype', > > 'joinTable' => 'activity_statuses', > > 'foreignKey' => 'activities_id', > > 'associationForeignKey' => 'statustypes_id', > > 'unique' => false, > > 'conditions' => '', > > 'fields' => '', > > 'order' => '', > > 'limit' => '', > > 'offset' => '', > > 'finderQuery' => '', > > 'deleteQuery' => '', > > 'insertQuery' => '' > > ), > > ); > > > ActivityStatus: > > > var $belongsTo = array( > > 'Statustype' => array( > > 'className' => 'Statustype', > > 'foreignKey' => 'statustypes_id', > > 'conditions' => '', > > 'fields' => '', > > 'order' => '' > > ), > > 'Activity' => array( > > 'className' => 'Activity', > > 'foreignKey' => 'activities_id', > > 'conditions' => '', > > 'fields' => '', > > 'order' => '' > > ), > > ); > > > I don't define any relationships in the Statustype model. > > [snip] -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
