Re: Tagging system in Cake - hasAndBelongsToMany problems

2009-04-05 Thread Ben Coleman
Thanks for the input I've tried everything suggested, and none of them work. The strange thing is my save/create/update behaviour is working, so Tags and Games are getting created and linked properly during updates & deletes - I infer from this that my associations & models are set up OK. With t

Re: Tagging system in Cake - hasAndBelongsToMany problems

2009-04-05 Thread Walther
Use the containable behaviour. $this->Game->Tag->find('all', array('conditions' => array('Tag.name' => 'foo'), 'contain' => array('Game' => array('Genre', 'System')); As long as your associations are correctly configured it should work. Read up about it at http://book.cakephp.org/view/474/Contai

Re: Tagging system in Cake - hasAndBelongsToMany problems

2009-04-04 Thread brian
Have a look at this tip: http://bakery.cakephp.org/articles/view/quick-tip-doing-ad-hoc-joins-in-model-find On Sat, Apr 4, 2009 at 6:07 AM, Ben Coleman wrote: > > Hi, > > I've been using Cake for some time, but recently hit a problem with > hasAndBelongsToMany. > I have a videogame database, I'

Re: Tagging system in Cake - hasAndBelongsToMany problems

2009-04-04 Thread Teh Treag
Ben, Here is an example from the book - http://book.cakephp.org/en/view/83/hasAndBelongsToMany-HABTM -teh $this->Recipe->bindModel(array( 'hasOne' => array( 'RecipesTag', 'FilterTag' => array( 'className' => 'Tag',

Tagging system in Cake - hasAndBelongsToMany problems

2009-04-04 Thread Ben Coleman
Hi, I've been using Cake for some time, but recently hit a problem with hasAndBelongsToMany. I have a videogame database, I'm trying to add a tagging system to it. I'm storing my tags in 3NF. So I have a model for games which is binding Games to Tags with hasAndBelongsToMany and also my Tag mode