To specify the order just do something like:
$order = 'name';
and then use it in the fetchall as before (i've spent 2 hours tracking this down today myself) how you specify desc if you need it I'm not sure.
Can you spot a way of missing out the WHERE clause, at the moment I have
$where = $tablename->getAdapter()->quoteInto('LastName <> ?', '');
and then
$someView = $tablename->fetchAll($where, $order);
But the $where part is just a space holder.
Cheers
Amos
|