Re: Fetching data with join over 3 tables with recursive association query

2006-11-01 Thread lloydhome
Well, it seems I have found the previously reported Trac #633. The partial workaround mentioned by elsigh is clumsy, messy, and may not work for some implementations but has the advantage of actually working without changing core code. My implementation requires a proper recursion depth to be sp

Re: Fetching data with join over 3 tables

2006-10-31 Thread lloydhome
I have used CakePHP for several months and answered a few posts without needing to post and I probably don't need to now but I cannot find the answer. I have tried setting the recursive var to 2, 3, 4, 5 and no help to my problem. I have a User model that has a belongsTo a Subarea that belongsTo

Re: Fetching data with join over 3 tables

2006-10-23 Thread Preloader
Tested a little bit - one interesting point: if I have a field "Artist" in my albums table it got overwritten by the Artist recursion, so watch out :-) ... ... here the new structure: ___ Array ( [0] => Array ( [Artist] =>

Re: Fetching data with join over 3 tables

2006-10-23 Thread Preloader
Oh ... thank you very much, it works great! Maybe I should learn the hole API by heart before coding one single line. :-) Thanx, Christoph --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post

Re: Fetching data with join over 3 tables

2006-10-23 Thread Samuel DeVore
try adding $this->Artist->recursive = 2; (or other recursion level defaults to 1) values -1 only the model of interest NO joins 0 only the root level (may include belongsTo and hasOne 1 only first level of hasMany and hasAndBelongsToMany 2 ok I bet you can guess ;) hth, if not hope for someone

Fetching data with join over 3 tables

2006-10-23 Thread Preloader
Hello cakePHP-Community, first of all a "Big Hello" to everybody. My name is Christoph and I'm new to this group. I mainly coded Perl & PHP in the last years. Due to constantly growing projects I was looking for a simple and cleary arranged Web Application Framwork. (yeah, it took me long, but he