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