[fw-general] Dynamic orWhere Clause | Zend_Db_Select

[Shaun Farrell]

Are you able to do this?

$teamTags = an array or strings

        $select = $this->getTable()->select();

foreach($teamTags as $tags) {
            $select->orWhere('Text like ?', '%' . $tags['Tag'] . '%');
        }

        $select->where('(Create_Dt < ?', '2009-10-24 23:59:59')
            ->where('Create_Dt > ?)', '2009-10-24 00:00:01')
            ->order('Id DESC')
            ->limit(10);

        $result = $this->getTable()->fetchAll($select);

If you echo the $select it's fine.
if you try to do fetchAll() it doesn't work.

any thoughts?

-- 
Shaun J. Farrell
Washington, DC
(202) 713-5241
www.farrelley.com