Thanks for taking a look guys. I knew there was reason why it made sense to me that the dates weren't populating, just wasn't sure if there was a work around.
Thanks for the advice, I'll get it set with the join model and go from there. Thanks again. On Feb 17, 3:10 pm, euromark <[email protected]> wrote: > 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
