Re: query

@Chris: You're openly admitting you have not looked at how CakePHP is
*supposed* to be used at all. Before you start recommending to others
that they should just bail on major core concepts of the framework,
you should take the time to go through the cookbook. If you did you
would quickly learn how recursive and containable work and see the
error of your previous developers ways.

What you have is an app developed by someone that did not know what
they were doing with CakePHP and possibly even with databases (pulling
our FAR too much data in one go). You've then taken that application
over and assumed that person was using the framework correctly.

You should take the time to learn CakePHP, you will find all sorts of
goodness in the framework that you are obviously unaware of.

Good luck, Paul.

On Nov 2, 8:50 am, AD7six <andydawso...@gmail.com> wrote:
> On Oct 30, 9:50 am, SERKAN TURAN <serkantu...@gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
> > I have an query and I could not figure it out what is the cakephp form of
> > it.
>
> > query:
> > -------------------------------------------
> > SELECT *
> > FROM
> >   tags`
> >   INNER JOIN `tags_articles` ON (`tags`.`id` = `tags_articles`.`tag_id`)
> >   INNER JOIN `articles` ON (`tags_articles`.`article_id` = `articles`.`id`)
> > WHERE
> >   `articles`.`isRead` = 'Not' AND
> >   `tags`.`id` = 3 AND
> >   `articles`.`status` = 'New'
> > ORDER BY
> >   `articles`.`name` DESC
> > --------------------------------------------------------------------------- -------------------
>
> Serkan,
>
> Your question is almost the same as the example in the book.
>
> See "It's also possible to create an exotic association for the
> purpose of creating as many joins as necessary to allow filtering, for
> example:"http://book.cakephp.org/view/1044/hasAndBelongsToMany-HABTM
>
> have a go and post a follow up if you do not succeed. Tip: search from
> Article, not Tag.
>
> AD

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php