Re: [fw-general] Dynamic orWhere Clause | Zend_Db_Select

2009-10-24 Thread Shaun Farrell
Actually I have narrowed it down to the ajax i think. I can call the method in the model and it works fine. However when I call the action via ajax it leaves out the orWhere loop. Seems odd to me. On Sat, Oct 24, 2009 at 6:33 PM, Hector Virgen wrote: > What is the error? If you can echo the S

Re: [fw-general] Dynamic orWhere Clause | Zend_Db_Select

2009-10-24 Thread Hector Virgen
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 wrote: > Are you able to do this? > > $teamTags = an array or strings > > $select = $this->getTable()->select(); > > foreach($teamTags as

[fw-general] Dynamic orWhere Clause | Zend_Db_Select

2009-10-24 Thread 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') ->wh