Re: SUBQUERY Question

2009-05-03 Thread harpax
Hello Fabian, Are you sure that you have a HABTM relationship or a belongsTo? In your query there is a field 'user.verse_id', that is not needed. For a habtm, there should be three tables in your db: -- USERS: == id, name, ... VERSES: === id, name, ... USERS_VERSES: == id,

SUBQUERY Question

2009-04-28 Thread Fabian
Hey, I'm so happy I've found this group. Maybe someone can help me with my problems here (I'm a beginner in Cakephp). Sorry for my bad english by the way. Ok I've got two Models in HABTM relation: verses and users. in my controller action i want to get some specific verses (for example: the