What is the error? If you can echo the SQL but not query it, it's probably a syntax error.
-- Hector On Sat, Oct 24, 2009 at 1:26 PM, Shaun Farrell <[email protected]> wrote: > 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 >
