Using a Zend_Db_Expr

Question

I have the following query:

$select = $this->getDao()->select()
                         ->from(
                           array(new Zend_Db_Expr('FROM_UNIXTIME(expiration)'))
                           );

The getDao function is a reference to my Data Access object class which looks like this:

class Model_Db_AccountresetDao extends Zend_Db_Table_Abstract
{
    protected $_name = 'accountreset';
    protected $_primary = 'reset_id';
}

Now i get this following error:

"Select query cannot join with another table"

This while i don't want to do a join. I just want to select that field as a unixTimestamp

How can I solve this problem?

All help is appreciated.

Tnx

j0k · Accepted Answer · 2012-12-12 08:39:11Z

3

If you are gettin select object from Zend_Db_Table_Abstract you can't pass him a ->from(). I think you should do like this

$select = $this->getDao()->select()  
                         ->from(this->getDao(),
                           array('_date or some field='.new Zend_Db_Expr('FROM_UNIXTIME(expiration)'))
                           );

or something like this.

edited Dec 12, 2012 at 8:39

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Dec 1, 2010 at 14:53

Vadyus

1,3298 silver badges19 bronze badges

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

2 Comments

sanders Over a year ago

But then it become a condition and i don't want it to be a condition. I just want to select that field in a different format.

Vadyus Over a year ago

->from give's the select object table name to select from, you should you ->select(array('date'=>new Zend_Db_Expr('FROM_UNIXTIME(expiration)') to pass fields you wanna select

Collectives™ on Stack Overflow

Using a Zend_Db_Expr

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related