Should not have posted so fast. I seem to have found a solution:
$this->Script->unbindModel(
array('belongsTo' => array('Category'))
);
That temporally removes the relationship. Works perfectally to remove
the extra join. But it still performs quarry #2, "DESCRIBE
`categories`". humph. Why does it do that?
Thanks,
Jonah
On Jun 20, 9:54 pm, "Turnquist, Jonah" <[EMAIL PROTECTED]> wrote:
> BTW i am using CakePHP 1.2
>
> On Jun 20, 9:33 pm, "Turnquist, Jonah" <[EMAIL PROTECTED]> wrote:
>
> > Ok, so I have a Scripts table, holding php script entries (tutorials),
> > a Categories table, and a Users table. Each script has a category and
> > a user. I have all the hasMany belongsTo etc set up properly.
>
> > On my /scripts page, under the index action it lists all of the
> > scripts, displaying the script title, and it's user that created it,
> > but not it's category. So it should not even fetch category data. So
> > this is what it needs to fetch:
>
> > [0] => Array
> > (
> > [Script] => Array
> > (
> > [id] => 1
> > [title] => DB connect
> > [created] => 2001-06-18 16:05:40
> > [description] => This class that will connect to the
> > database test
> > )
>
> > [User] => Array
> > (
> > [name] => man
> > [id] => 1
> > )
>
> > )
>
> > The find() code that is working and doing the above:
>
> > $this->set('scripts', $this->Script->find('all', array(
> > //'recursive' => -1, //this is commented out
> > 'fields' => array('Script.id', 'Script.title', 'Script.created',
> > 'Script.description', 'User.name', 'User.id'),
> > )
> > ));
>
> > Setting the 'fields' option kept it from returning any categories
> > data.
>
> > This successfully returns the correct data. BUT, when I looked at the
> > quarries, I saw a problem:
> > 1) DESCRIBE `scripts`
> > 2) DESCRIBE `categories` //not needed!
> > 3) DESCRIBE `users`
> > 4) SELECT `Script`.`id`, `Script`.`title`, `Script`.`created`,
> > `Script`.`description`, `User`.`name`, `User`.`id` FROM `scripts` AS
> > `Script` LEFT JOIN `categories` AS `Category` ON
> > (`Script`.`category_id` = `Category`.`id`) LEFT JOIN `users` AS `User`
> > ON (`Script`.`user_id` = `User`.`id`) WHERE 1 = 1 //excessive!
>
> > You see, it is doing a left join on categories in quarry #4, and
> > quarry #2 is not even needed. I understand joins can be slow. Thus I
> > am asking how can I get rid of it
>
> > I tried setting the option 'recursive' => -1 (you can see it commented
> > out), but that obviously stops it from collecting the user data too.
> > So I guess what I need is a partial recursion? So it performs
> > recursion to the Users table but not the Categories table? How can
> > this be done? any ideas?
>
> > Thanks,
> > Jonah (is very new to cake BTW, try not to use big words lol
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
