Hi Guys,

I have been racking my brain on this one. I am trying to display the recent posts from a particular blog on my homepage, kind of a latest news snippet. Sounds easy since I can use related posts module already built in. But what I want is to use the summary field or better again if I could, use the description field BUT I want to limit the characters returned (so I don't get the full post , say 200)
I have been using the reports module to try it out and have come close with the below query, however I get column headers and no links to the actual post. What I want is Title (to be the link) the date posted next to it on the same line and on the next line a snippet of the post.

SELECT TOP 3
     Blog_Blogs.Title as 'Source'
    ,Blog_Entries.Description as 'Summary'
    ,Blog_Entries.AddedDate as 'Date'
FROM
    Blog_Entries
    INNER JOIN Blog_Blogs on Blog_Entries.BlogID = Blog_Blogs.BlogID
WHERE
    Blog_Blogs.PortalID = @PortalID
    AND Blog_Blogs.[Public] = '1'
    AND Blog_Entries.Published = '1'
ORDER BY
    Blog_Entries.EntryID DESC

Leslie,

Thanks for that, its really good, I have been trying to do this for a while.

How do you have the blg modules set up on your news page? When I click the article on the home page it takes me to the news page but doesnt open the article.

Many Thanks, John

Hi Leslie,

Thanks it is working now.

Cheers, John