View Single Post
  #6 (permalink)  
Old 10-29-2007, 03:17 PM
amos's Avatar
amos amos is offline
Junior Member
 
Join Date: Oct 2007
Posts: 1
Default

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
Reply With Quote