Humm.. Ok.
What about fields?
Please, take a look at http://manual.cakephp.org/view/82/hasmany
On Mon, Jun 23, 2008 at 8:10 PM, Turnquist, Jonah <[EMAIL PROTECTED]>
wrote:
>
> 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
> >
>
--
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
-~----------~----~----~----~------~----~------~--~---
