Re: $conditions 'reset' key in terms of Containable
Something I just discovered and maybe the more important question - why doesn't Containable work on HABTM 'with' relationships? On Jun 16, 10:23 pm, eric.winch...@gmail.com eric.winch...@gmail.com wrote: Can anyone describe why 'reset'=false must be in $conditions for Containable usage of any complexity? I have queries that go from taking an unbearable 20 seconds to an almost unbearable 3 seconds, but I don't understand what 'reset' has to do with it. The ones where it really counts are using up to 3 levels of recursiveness. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: $conditions 'reset' key in terms of Containable
There's a 'reset' param? Is that documented anywhere? On Tue, Jun 16, 2009 at 11:23 PM, eric.winch...@gmail.comeric.winch...@gmail.com wrote: Can anyone describe why 'reset'=false must be in $conditions for Containable usage of any complexity? I have queries that go from taking an unbearable 20 seconds to an almost unbearable 3 seconds, but I don't understand what 'reset' has to do with it. The ones where it really counts are using up to 3 levels of recursiveness. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: $conditions 'reset' key in terms of Containable
Not documented as far as I know. It's just Containable weirdness, probably having to do with binding. Anyone know why Containable doesn't work with HABTM 'with' relationships? I had it working when it was a 3rd party behavior, but it's definitely not working now. For me, deep SQL queries is the most frustrating part of using Cake. On Jun 16, 11:37 pm, brian bally.z...@gmail.com wrote: There's a 'reset' param? Is that documented anywhere? On Tue, Jun 16, 2009 at 11:23 PM, eric.winch...@gmail.comeric.winch...@gmail.com wrote: Can anyone describe why 'reset'=false must be in $conditions for Containable usage of any complexity? I have queries that go from taking an unbearable 20 seconds to an almost unbearable 3 seconds, but I don't understand what 'reset' has to do with it. The ones where it really counts are using up to 3 levels of recursiveness. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: $conditions 'reset' key in terms of Containable
Arrghh I'm feeling stupid now. Here's how you use HABTM Containable
and paginate all at once:
$this-paginate['AreaAlbum'] = array(
'conditions'=$conditions,
'limit' = 4,
'page' = 1,
'order'='AreaAlbum.album_id desc',
'contain'=array('Album'=array('User'=array('first_name',
'last_name', 'id'), 'CoverImage'=array('WebResource', 'FileType')))
);
$albums = $this-paginate('AreaAlbum');
This is what I was trying to do before:
$this-AreaAlbum-contain('Album.User.first_name',
'Album.User.last_name', 'Album.User.id',
'Album.CoverImage.WebResource', 'Album.CoverImage.FileType');
$albums = $this-paginate('AreaAlbum');
Apparently the array format + $conditions is the way to go with
paginate.
On Jun 16, 11:55 pm, eric.winch...@gmail.com
eric.winch...@gmail.com wrote:
Not documented as far as I know. It's just Containable weirdness,
probably having to do with binding.
Anyone know why Containable doesn't work with HABTM 'with'
relationships? I had it working when it was a 3rd party behavior, but
it's definitely not working now. For me, deep SQL queries is the
most frustrating part of using Cake.
On Jun 16, 11:37 pm, brian bally.z...@gmail.com wrote:
There's a 'reset' param? Is that documented anywhere?
On Tue, Jun 16, 2009 at 11:23 PM,
eric.winch...@gmail.comeric.winch...@gmail.com wrote:
Can anyone describe why 'reset'=false must be in $conditions for
Containable usage of any complexity? I have queries that go from
taking an unbearable 20 seconds to an almost unbearable 3 seconds, but
I don't understand what 'reset' has to do with it. The ones where it
really counts are using up to 3 levels of recursiveness.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
