Select query cannot join with another table - JOIN Zend Framework
11,471
<?php
class Application_Model_DbTable_Seguimientos extends Zend_Db_Table_Abstract {
protected $_name = 'Seguimientos';
public function buscarCaso($cod_beneficiario) {
$consulta = $this->select()
->from(array('seg' => 'Seguimientos'))
->join(array('casos' => 'Asuntos_Estudiantiles'),
'seg.cod_radicado = casos.codigo_radicado')
->where('casos.cod_beneficiario = ?', $cod_beneficiario)
->setIntegrityCheck(false); // ADD This Line
$query = $this->fetchAll($consulta)->toArray();
return $query;
}
}
Solved by adding ->setIntegrityCheck(false)
! =)
An explanation of why this helps is found at this question/answer
Author by
Jhosman
Updated on June 12, 2022Comments
-
Jhosman almost 2 years
An error occurred Application error Exception information:
Message: Select query cannot join with another table This is my code:
<?php class Application_Model_DbTable_Seguimientos extends Zend_Db_Table_Abstract { protected $_name = 'Seguimientos'; public function buscarCaso($cod_beneficiario) { $consulta = $this->select() ->from(array('seg' => 'Seguimientos')) ->join(array('casos' => 'Asuntos_Estudiantiles'), 'seg.cod_radicado = casos.codigo_radicado') ->where('casos.cod_beneficiario = ?', $cod_beneficiario); $query = $this->fetchAll($consulta)->toArray(); return $query; } }
I use Zend Framework 1