Ok thanks. I think you misunderstood the first question though
>>> How do I limit the columns from the second quarry?
I meant how do you limit which columns are returned, for instance, I
want to return 'name', 'created' and 'description' from the table, but
not 'content'
On Jun 23, 3:37 pm, "Renan Gonçalves" <[EMAIL PROTECTED]> wrote:
> > How do I limit the columns from the second quarry?
>
> You set limit propertie in your hasMany relationship, like:
>
> $this->Category->hasMany['Script']['limit'] = 10;
> $this->Category->find...
>
> Also, why is cake not doing a join, but instead two separate quarries?
>
> > wouldn't that be faster?
>
> Joins are used in belongsTo and hasOne relationship.
>
> []'s
>
> On Mon, Jun 23, 2008 at 7:14 PM, Turnquist, Jonah <[EMAIL PROTECTED]>
> wrote:
>
>
>
>
>
> > Ok, now I have another question. I understand that I can set 'fields'
> > to return only some of the table columns of the categories table. But
> > how do I limit the columns returned from the Scripts/Entries table
> > which also gets pulled because of my hasMany definition?
>
> > 1 SELECT `Category`.`name`, `Category`.`id` FROM `categories` AS
> > `Category` WHERE `Category`.`id` = 2 LIMIT 1
>
> > 2 SELECT `Script`.`id`, `Script`.`title`, `Script`.`description`,
> > `Script`.`content`, `Script`.`category_id`, `Script`.`user_id`,
> > `Script`.`created`, `Script`.`modified` FROM `scripts` AS `Script`
> > WHERE `Script`.`category_id` IN (2)
>
> > How do I limit the columns from the second quarry? Doing this
> > prevented it from pulling `created` from Categories:
> > $this->set('category', $this->Category->read('name')); //(it still
> > pulls the id though, so I am assuming you can not prevent that)
> > //or (seems to do the same thing)
> > $this->set('category', $this->Category->find(array('id' => $id),
> > 'name'));
>
> > Also, why is cake not doing a join, but instead two separate quarries?
> > wouldn't that be faster?
>
> > I would think this would work:
> > $this->set('category', $this->Category->find( array('id' => $id),
> > array('Category.name', 'Script.title', 'Script.description') ));
> > But it doesn't! grr
>
> > Thanks,
> > Jonah
>
> --
> Renan Gonçalves - Software Engineer
> Cell Phone: +55 11 8633 6018
> MSN: [EMAIL PROTECTED]
> São Paulo - SP/Brazil
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
