PHP | Problem - SS3 - Leftjoin
<?php
class ProjectImage extends Image {
public static $default_sort = "Sorting ASC";
public static $has_one = array('ProjectPage' => 'ProjectPage');
public static $db = array(
'Home' => 'Boolean',
);
}
?>
<?php
class ProjectPage extends Page {
static $has_many = array('Images' => 'ProjectImage');
}
?>
<?php
class HomePage extends Page {
public function Images() {
$ar = ProjectPage::get()->leftJoin("ProjectImage", "\"ProjectImage\".\"ProjectPageID\" = \"ProjectPage\".\"ID\"");
return $ar;
}
}
?>
SQL Error:
|
|
21/10/2012 8:42am
PHP | Solution - Anonymous
ProjectPage::get()->filter('Images.Home:ExactMatch', 1)