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
-~----------~----~----~----~------~----~------~--~---
