3063 Posts in 864 Topics by 646 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 706 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
| 706 Views | ||
|
Page:
1
|
Go to Top |

