Archive for July, 2010

While creating a SQL query in ZF I kept getting an error with my joins. I was able to fiz this using the code below.


$fooTable = new DbTable_Foo();
$select = $fooTable ->select(Zend_Db_Table::SELECT_WITH_FROM_PART);

$select->setIntegrityCheck(false) //Set integrity check is what did the trick for me.
->join('foo', 'bar.id = foo.id')
->where('foo.id = '.id);
$fooRowset = $this->getDbTable()->fetchAll($select);


I have ran into an issue/bug with zend studio/eclipse IDE, every once an a while code completion will stop working. I have not been able to pin down what exactly causes the problem, but here is my fix.

Delete the following file in the Zend Studio workspace:

Zend/workspaces/<your workspace name>/.metadata/.plugins/org.eclipse.core.runtime/.settings/org.eclipse.dltk.ui.prefs