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: > https://

Re: findAll, associations, HABTM

2007-12-11 Thread Mr-Yellow
https://trac.cakephp.org/ticket/1674 This is a great idea, much better then the current confusing, limited, exploitable implementation. Saying "Coders should always add =" "worksforme" doesn't make it any more secure or usable. Coders don't know to do so, no amount of education will fix it. Wai

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 sp

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 a

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 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 wag

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 whe

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 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 t