Sure do ... but no love.
On Oct 6, 12:05 pm, majna <[EMAIL PROTECTED]> wrote:
> Example:http://teknoid.wordpress.com/2008/09/05/example-of-cakephps-containab...
> Do you have Containable behavior included in model (var $actsAs =
> array('Containable');) ?
>
> On Oct 6, 8:44 pm, Brenton B <[EMAIL PROTECTED]> wrote:
>
> > uh ... k ...
>
> > So for models there's the "find" function, whose first parameter can
> > be an assortment of strings depending on what you want to find ...
> > well, one of the ones I'm using is "list", which will generate a list
> > that's for easier usage in a select list.
> > Then there's also the possibility of an array of options as the second
> > parameter. One of these possible options is the "contain" key, which,
> > when used, would denote what associations to use while doing the find.
> > This option doesn't seem to take affect when I use it in conjunction
> > with `find('list')`.
> > Another thing you an do with the second 'options' array parameter is
> > declare how you want the list returned, and what it is to be grouped
> > by, for the select list.
>
> > In my case, I have a list of States ... I want them grouped by Country
> > name .... Therefore, I'm calling it like this:
>
> > $states = $this->User->State->find('list',
> >
> > array('contain' => array('Country'),
> >
> > 'fields' => array('State.id', 'State.name', 'Country.name')
> > ));
>
> > However, it barks and complains that "Warning (512): SQL Error: 1054:
> > Unknown column 'Country.name' in 'field list'", which is because
> > 'Country' isn't included int he query ("Query: SELECT `State`.`id`,
> > `State`.`name`, `Country`.`name` FROM `states` AS `State` WHERE 1 =
> > 1 ORDER BY `State`.`name` ASC "), because (I'm assuming) "contain"
> > does not work.
>
> > If I do `find('all')` (with everything else being the same), it
> > returns without error ... albeit, completely screwed up for the select
> > list .... if I do 'State.country_id' for the "group" field (3rd in the
> > 'fields' array), it returns without error, albeit using the id and not
> > the name for the group.
>
> > Details added.
>
> > Confused or understood?
>
> > On Oct 6, 11:27 am, AD7six <[EMAIL PROTECTED]> wrote:
>
> > > On Oct 6, 8:20 pm, Brenton B <[EMAIL PROTECTED]> wrote:
>
> > > > Apparently doing `find('list')` doesn't like to take into account the
> > > > "contain" option.
> > > > Is this on purpose?
>
> > > > Scenario:
> > > > Have a list of States that needs to be grouped by Country name, 2
> > > > separate tables where State has the country_id.
>
> > > > Bug or intentional?
>
> > > Details missing
>
> > > deliberate or mistake?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
