Problem with sql in zend framework

Question

I wanted to get a sql query, for example SELECT numbers FROM table ORDER BY numbers+0; as part of zend.

I am new to zend. Can someone please help me with this.

Thanks.

Answer 1

How about this:

  $db = Zend_Db_Table::getDefaultAdapter(); $select = $db->select()->from('table','numbers')->order(new Zend_Db_Expr('numbers+0')); var_dump($select->assemble()); //outputs: //string 'SELECT `table`.`numbers` FROM `table` ORDER BY numbers+0' (length=56) 

new Zend_Db_Expr necessary because without it ZF will add "ASC" to your request:

  $db = Zend_Db_Table::getDefaultAdapter(); $select = $db->select()->from('table','numbers')->order('numbers+0'); var_dump($select->assemble()); //outputs: //string 'SELECT `table`.`numbers` FROM `table` ORDER BY `numbers+0` ASC' (length=62) 

Hope this helps.