Problem with sql in zend framework

Question

I wanted to get the sql query like SELECT numbers FROM table ORDER BY numbers+0; in zend framework.

I am new to zend. Can anyone please help me on this.

Thank you.

sure .. you are welcome. And welcome to SO.

S L
– S L

2011-03-27 13:16:36 +00:00
Commented Mar 27, 2011 at 13:16 — S L
– S L, Commented Mar 27, 2011 at 13:16

Marcin · Accepted Answer · 2011-03-27 12:07:04Z

5

What 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 is needed because without it, ZF will add 'ASC' to your query:

    $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.

edited Mar 27, 2011 at 12:07

answered Mar 27, 2011 at 11:28

Marcin

241k16 gold badges315 silver badges368 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with sql in zend framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related