Hi,
for the else-tree below i want to get all data from "Referenz" joining "Stammdaten". But the result should be limited to the first hit of "Stammdaten.Firmenname" with a match in "Referenz". How can i get the id from a first statement like:
$id = DataObject::get("Stammdaten", "", "Stammdaten.Firmenname", "LEFT JOIN Referenz ON Referenz.Kunde = Stammdaten.ID", "");
to pass it to the second query? Something like $id->ID?????
Thanks for your help.
Code:
function getReferenzenVonFirmen() {
// Debug::show(@Director::urlParam('ID')); die();
$id = @Director::urlParam('ID');
// Debug::show($id); die;
if($id > NULL) {
$Referenzen = DataObject::get("Referenz", "Referenz.Anzeigen = 1 AND BildEinsID > 0 AND StammdatenID = ".$id."", "StammdatenID", "", "");
} else {
$Referenzen = DataObject::get("Referenz", "Referenz.Anzeigen = 1 AND BildEinsID > 0", "Stammdaten.Firmenname", "LEFT JOIN Stammdaten ON Referenz.StammdatenID = Stammdaten.ID", "");
}
//Debug::show($Referenzen); die;
return $Referenzen;
}