Try this:
find('list', array('order'=> 'field'));
On Apr 24, 11:21 pm, "b logica" <[EMAIL PROTECTED]> wrote:
> cake_1.2.x.x_24.01.2008
>
> I need to specify an order on a find('list') call and nothing I've
> tried is working :-(
>
> Is the new find() format documented anywhere? I can't even remember
> where I learned about it. Can 'list' be ordered?
>
> For the interested, here's the relevant hunk of model.php:
>
> case 'list' :
> if (empty($query['fields'])) {
> $query['fields'] = array("{$this->alias}.{$this->primaryKey}",
> "{$this->alias}.{$this->displayField}");
> $keyPath = "{n}.{$this->alias}.{$this->primaryKey}";
> $valuePath = "{n}.{$this->alias}.{$this->displayField}";
> $groupPath = null;
> } else {
> if (!is_array($query['fields'])) {
> $query['fields'] = String::tokenize($query['fields']);
> }
> if (count($query['fields']) == 1) {
> $keyPath = "{n}.{$this->alias}.{$this->primaryKey}";
> $valuePath = '{n}.' . $query['fields'][0];
> $groupPath = null;
> $query['fields'] =
> array("{$this->alias}.{$this->primaryKey}",
> $query['fields'][0]);
> } elseif (count($query['fields']) == 3) {
> $keyPath = '{n}.' . $query['fields'][0];
> $valuePath = '{n}.' . $query['fields'][1];
> $groupPath = '{n}.' . $query['fields'][2];
> } else {
> $keyPath = '{n}.' . $query['fields'][0];
> $valuePath = '{n}.' . $query['fields'][1];
> $groupPath = null;
> }
> }
>
> Believe me, I've tried! If it's impossible, I can always re-order the
> array when I get it. Or I could create a view in Postgres to keep any
> selects to this table ordered the way I want (it's a lookup table,
> basically, but order is important). But I'm curious is this can be
> done directly.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
