2508 Posts in 675 Topics by 520 members
Data Model Questions
SilverStripe Forums » Data Model Questions » public function BlogEntries
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba
|
Page:
1
|
Go to End | |
| Author | Topic: | 584 Views |
-
public function BlogEntries

6 May 2009 at 7:45am
Hi,
How is it that using this function, with DataObject::get('Page', etc.), we are able to separate the Tags into individual links on the template level ($Link?tag=$Tag), but if I try to customise the query using DB:query(), all I get back from the BlogEntry table is the Tags column as one solid block?
Because I need to do a couple of JOIN's, I need to use DB:query():
SELECT ST.Title, ST.Content, ST.URLSegment, BE.*, F.FileName AS ListingImage FROM BlogEntry BE
JOIN SiteTree ST ON ST.ID = BE.ID
LEFT JOIN File F ON F.ID = BE.ListingImageIDThen:
foreach($item as $sqlResult) {
$Tags = $sqlResult['Tags'];
Etc.$results->push(new ArrayData(array(
"Tags" => $Tags,
Etc.
)));
}
return $results;How can I pass the Tags back pre-split? They're already inside an array. Help!
Thanks,
Garrett
| 584 Views | ||
|
Page:
1
|
Go to Top |

