Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Randomly load ChildrenWithLimit


Reply

3 Posts   536 Views

Avatar
mhull

11 July 2009 at 4:15am Community Member, 79 Posts

I am using the following code to pull 2 children of the StaffHolderpage into the Homepage.

Page.php:

function ChildrenWithLimit($limit = 2) {
return DataObject::get('Page', "ParentID = $this->ID", '', '', $limit);
}

Homepage.ss:

<% control Page(about-us) %>

<ul id="StaffList">
<% control ChildrenWithLimit %>

<li>
<div class="staffname"><a href="$Link">$Title</a></div>
<div class="staffphoto">$Photo</div>
<div class="staffdescription"><p>$Content.FirstSentence</p></div>
</li>
<% end_control %>
<% end_control %>


But what I hope to do, is to randomly choose 2 of these. Is this possible? how would it be done? Any help would be much appreciated.

Avatar
banal

11 July 2009 at 5:28am Community Member, 901 Posts

Hi
Using "RAND()" for the sorting should do the trick. Eg.

return DataObject::get('Page', "ParentID = $this->ID", 'RAND()', '', $limit);

Avatar
mhull

11 July 2009 at 9:02pm Community Member, 79 Posts

Many Thanks for your help, this all seems to be working!