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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo

Problem auto-detecting Page or Page_Live


Go to End


2 Posts   1423 Views

Avatar
blueskies

Community Member, 44 Posts

10 April 2008 at 8:58pm

Hi all,

I've been busy with this little gem for a while now and can't find any leads anywhere, so I'm hoping someone can point me in the right direction. In a ProductPage_Controller class I have the following custom function:

function OtherProducts() {
return DataObject::get("ProductPage", "ParentID = {$this->ParentID} AND ProductPage.ID!={$this->ID}", "Created ASC", "","5");
}

This returns all ProductPages under the current parent excluding the current page (in other words: all _other_ pages under this parent).

The problem is that ProductPage.ID, of course, gives an error (unknown column) when working with Live data, because it should be ProductPage_Live.ID. I can't find any way to (preferably) stick a variable in it so it can determine auto-magically whether it should be ProductPage or ProductPage_Live table.

P.S. I can't just make it ID!={$this->ID} because then it throws an error that the ID field is ambiguous....

Avatar
Fuzz10

Community Member, 791 Posts

11 April 2008 at 12:42am