Another query about some modifications to the gallery widget..
I need to be able to pull out an image (doesn't matter which) from one of the listed galleries.
function Galleries() {
$nrtoshow = (0<$this->NumberToShow) ? "0,".$this->NumberToShow : "";
$galleries = DataObject::get(
"Page",
"SiteTree_Live.ClassName = 'GalleryPage' AND ShowInMenus = 1",
"LastEdited DESC",
"",
"$nrtoshow"
);
return $galleries;
}
I tried adding a join:
LEFT JOIN GalleryPage ON SiteTree_Live.ID = GalleryPage.ID LEFT JOIN File ON (GalleryPage.FolderID = File.ParentID AND File.ClassName='Image')
but because it is a page object am unable to output an Image object. Is there a way I can do this?