RE: findAll, associations, HABTM

2007-12-11 Thread websta*
Yeah this is one that has plagued me too. I found some code for a workaround by defining a simple extra association in your model, and requiring some small changes to the model::find method that can be implemented in your app_model. I found this code in the bakery I think, modded it a bit though

Re: findAll, associations, HABTM

2007-12-11 Thread Mr-Yellow
Hacking the core really wouldn't do it for me, I guess the only proper way to use Cake is with hardcoded queries. As without this simple ability I'd rate the database abstraction as broken. Has it really be a year since the bug was posted??? Nothing? Am I choosing the wrong framework? -Ben

Re: findAll, associations, HABTM

2007-12-11 Thread jon
I know what you mean. I've spent three days to solve a problem that's three lines of regular PHP code and still no solution. Apparently CakePHP 'just works!' so doesn't need documentation. Yeah, well if it works, it's on minimum wage and giving surly customer service! And except for those days

Re: findAll, associations, HABTM

2007-12-11 Thread Chris Hartjes
On Dec 11, 2007 7:46 PM, jon [EMAIL PROTECTED] wrote: I know what you mean. I've spent three days to solve a problem that's three lines of regular PHP code and still no solution. Apparently CakePHP 'just works!' so doesn't need documentation. Yeah, well if it works, it's on minimum wage and

Re: findAll, associations, HABTM

2007-12-11 Thread Mr-Yellow
The new with attribute seems to go some way to fixing it, however the functionality has changed since first included and the tutorials out there are dated. If you include a model for your HABTM with, then query that model. Sorry for the non-naming convention tables, from older legacy system.

Re: findAll, associations, HABTM

2007-12-11 Thread Chris Hartjes
On Dec 11, 2007 10:25 PM, Mr-Yellow [EMAIL PROTECTED] wrote: As for writting CakePHP I think that would be better left to those with an eye on the direction and conventions of the project, those who should realise this is a feature at the basis of being able to use CakePHP for DB access.

Re: findAll, associations, HABTM

2007-12-11 Thread Mr-Yellow
Needed to use 'DISTINCT Pack.PackID' hack too. What does the unique attribute do in models,? Can't find it documented anywhere. -Ben On Dec 12, 12:44 pm, Chris Hartjes [EMAIL PROTECTED] wrote: On Dec 11, 2007 7:46 PM, jon [EMAIL PROTECTED] wrote: I know what you mean. I've spent three

Re: findAll, associations, HABTM

2007-12-11 Thread Mr-Yellow
http://tempdocs.cakephp.org/#TOC70554 This says The $conditions should be formed just as they would in an SQL statement Is the new way of doing it just pure SQL without all this array garbage that doesn't really work? -Ben On Dec 12, 4:02 pm, Mr-Yellow [EMAIL PROTECTED] wrote: