Hello!

I'm starting to use the fetchAll method of the DBTable class and I'm wondering how to sort columns descending. I'm using a Sql Server database.

The signature of fetchAll is:
fetchAll($where, $order, $count, $offset);

It seems that $order must be a column name. I tried $order='ORDER BY Name DESC' and it didn't work. $order='Name' worked. If that's the case, how do you order descending?

Thanks!
- Bret

Hi Bret.

I think you could try sending an array as parameter for the order:

array("Name" => "desc");

Hopefully this works for you.

Adrian

Try the Zend_Db_Select object!

/** $db Zend_Db_Adapter */

$select = $db->select()
->from('table', array('column1', 'column2'))
->order(array('column1 DESC', 'column2 ASC'));
$results = $db->fetchAll($select);

Regards,
AlesL

__________________
Internet Solutions - web development na sto in en način

Thanks for your advice. Sending in an array for the order didn't work. I'd really love to use the DBTable interface for this. Any other solutions using DBTable?

Thanks!
- Bret

Ah!! Wait! I think I'm down with the Zend_Db_Select object. I think that might be the golden ticket to happiness.

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

Use: fetchAll(null, "fieldname ASC/DESC")

Grtz,
Demo