hi
i'm still learning silverstripe but the documentation isn't very good for me so i have probably basic question for you
i want to add a new layer with SELECT FORM with values form database into my CMS
what is wrong ? i get empty select form
class TourPage extends Page {
static $db = array(
....
);
static $has_one = array(
....
);
function tour() {
$sqlQuery = new SQLQuery();
$sqlQuery->select = array(
'Title'
);
$sqlQuery->from = "SiteTree";
$sqlQuery->where = "ClassName = TourHolder";
$rawSQL = $sqlQuery->sql();
$result = $sqlQuery->execute()->result();
}
function getCMSFields() {
$fields = parent::getCMSFields();
....
....
$fields ->addFieldToTab("Root.Content.See Also", new DropdownField('ToursList', 'Tours',$result));
return $fields;
}
}
class TourPage_Controller extends Page_Controller {
}