I have a problem with a line on my SQL/Zend query, but I didn't understand about this.
public function getByDemande($idDemande, $typeTiers) {
$select = $this -> newSelect(true);
$select -> from(array('d' => 'Demande'));
$select -> join(array('s' => 'Suivi'), 'd."idDemande" = s."idDemande"');
$select -> join(array('t' => $typeTiers),'d."idContact" = t."idTiers"');
$select -> joinLeft(array('tet' => 'TelephoneTiers'), 't."idTiers" = tet."idTiers"');
$select -> joinLeft(array('mt' => 'MailTiers'), 't."idTiers" = mt."idTiers"');
$select -> join(array('at' => 'AdresseTiers'), 't."idTiers" = at."idTiers"');
$select -> where('d."idDemande" = s."idDemande"', $idDemande);
$select -> where('d.actif is true');
$select -> order('s.dateHeure DESC');
$resultat = $select->__toString();
echo "$resultat
";
return $this->fetchAll($select);
}
I launch my SQL/Zend query, but this throws an error (SQLSTATE[42601]: Syntax error: 7 ERREUR: identifiant délimité de longueur nulle sur ou près de « "" »↵LINE 3: INNER JOIN "" AS "t" ON d."idContact" = t."idTiers")
On the other file, I coded to recover data from this SQL query.
$data = $this->_getPostData();
$idDemande = $data['idDemande'];
$idTypeTiers = $data['idTypeTiers'];
$typeTiers = null;
$gtwDemande = new LogisCom_Model_Gateway_Demande();
$resultatDemande = $gtwDemande->getByDemande($idDemande, $typeTiers);
$resultatDemande = $resultatDemande->toArray();
switch ($idTypeTiers) {
case TypeTiers::BENEFICIAIRE :
$typeTiers = "Beneficiaire";
break;
case TypeTiers::SALARIE :
$typeTiers = "Salarie";
break;
case TypeTiers::PROSPECT :
$typeTiers = "Prospect";
break;
case TypeTiers::CANDIDAT :
$typeTiers = "Candidat";
break;
case TypeTiers::ENTOURAGE :
$typeTiers = "Entourage";
break;
case TypeTiers::FINANCEUR :
$typeTiers = "Financeur";
break;
case TypeTiers::AUTRE :
$typeTiers = "StructureExterne";
break;
}
Thanks for help.