Try $this->Article->recursive = -1;
But you could avoid having to update the field by instead selecting
from a sequence nextval('page_views') . If you can figure out how to
associate Article with something like a PageView model built around a
sequence.
I don't know if this is common or impossible with Cake, but it would
avoid the update. I'm also thinking of postgres; not sure what the
mysql way to do this is.
On Sat, May 10, 2008 at 6:52 PM, Ketan Patel <[EMAIL PROTECTED]> wrote:
>
> I am using Beta: 1.2.0.6311. I have a Article Table which is having
> associations with other tables like Category, Tags and User.
>
> I have a view counter in Article Table which would increment the
> counter each time the article is viewed. I am using the Restrict
> Behavior by Mariano. This is what I do in the article view controller
> action.
>
> $this->Article->restrict();
> $this->data = $this->Article->findById($id);
> $this->Article->restrict();
> $views = $this->data['Article']['views'] + 1;
>
> $this->Article->id = $this->data['Article']['id'];
>
> $this->Article->saveField('views', $views);
>
> This code does update the views but I am not sure why I get all the
> join statements in the UPDATE Sql statement? The following is the SQL
> statement issued to update only one field in Article.
>
> UPDATE `articles` AS `Article` LEFT JOIN `tags` AS `Tag` ON
> (`Tag`.`articles_id` = `Article`.`id`) LEFT JOIN `categories` AS
> `Category` ON (`Article`.`categories_id` = `Category`.`id`) SET
> `Article`.`views` = 646 WHERE `Article`.`id` IN (618)
>
> I am removing all the associations using 'restrict'. However, I have
> found a function _getJoins($model) in the dbo_source.php which is
> called explicity for all 'updates' and 'delete' calls. This is where
> the extra join statements are coming from. The above code does what is
> expected to do, but its adding this extra join statements which
> shouldn't be there if one removes the associations.
>
> What do you guys have to say?
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
