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

Querying multiple pages from ids in one db field


Go to End


4 Posts   1498 Views

Avatar
ChrisBryer

Community Member, 95 Posts

12 November 2008 at 6:54am

Edited: 12/11/2008 6:55am

hi everyone,
I have a 2x2 mysql table called 'Market' that contains an 'ID' column that maps to a Market's 'ID' in the SiteTree, and a 'MarketProducts' column that maps to ProductPage 'ID's in the SiteTree. here is what the table would look like:

ID | MarketProducts
24 | 25,26,28,29
27 | 25,29

on each Market's Page (who's id is contained in the first column, 'ID'), i want to display a Title and link to the ProductPages that are contained in the MarketProducts column. I am currently writing the controller for the class file, but am having problems with the DataObject::get method. here is what i have so far:

function Markets(){
$MP = DataObject::get("ProductPage", "ID = $this->MarketProducts");
return $MP;
}

the MarketProducts datatype is Varchar, and contains multiple IDs, comma separated. not sure if that is messing me up, but i know the syntax is wrong because the whole front end breaks on the Market pages.

sorry if this is a little confusing. I would appreciate any help anyone is willing to offer.
Thaks again,
-Chris

Avatar
ChrisBryer

Community Member, 95 Posts

13 November 2008 at 4:22am

just curious if anyone has any ideas on this. I would really appreciate some suggestions.

thanks,
-Chris

Avatar
Fuzz10

Community Member, 791 Posts

13 November 2008 at 5:20am

Hi Chris...

So if I understand correctly , you need a one to many relationship between markets and products , right ?

SS can do this for you out of the box ...

Have a look at the following tutorial :

http://doc.silverstripe.com/doku.php?id=tutorial:5-dataobject-relationship-management&s=has%20many

Keep us posted on your progress !

Avatar
ChrisBryer

Community Member, 95 Posts

14 November 2008 at 7:04am

that was exactly what i needed. thank you very much for your help.
-Chris