Re: [fw-db] natural order sorting in select object

tony stamp wrote:
>
> How can i do this with the zend_db_select object?
> $select->order('house_number +0 asc')
> does not work.
>

The Select object tries to quote identifiers, in case your column name
contains a SQL keyword, whitespace, or special characters.

Try this:

$select->order(new Zend_Db_Expr('house_number +0 ASC'));

Regards,
Bill Karwin
--
View this message in context: http://www.nabble.com/natural-order-sorting-in-select-object-tp19412845p19415048.html
Sent from the Zend DB mailing list archive at Nabble.com.