Hi,

I have put up a DNN site with forums. The forums is on a separate page from thee home page. I need a way of displaying the latest forum posts on the home page. When a user clicks on one of the latest forum posts, the user should be taken to the correct post in the Forums page.

I need to know how this can be done. Is there an existing module for the latest forum posts? The module should be put on a separate page from that of the forums page.

Thanks

I do the exact thing on the front of my site using the following SQL query and my SQLGridSelectedView modules

select top 5
  '<a href="'+PermaLink+'">'+ble.Title+'</a>' as [Latest Blog Entries]
from
    blog_entries ble
    inner join blog_blogs bb on bb.Blogid = ble.Blogid
where
    ble.Published = 1
    and bb.Portalid = 2    -- your portal number
    and bb.[public] = 1    -- ensure blog is public
order by
    ble.AddedDate desc

You could also use the Report Module to do the same thing.

Paul.

I'm confused.  I thought the question was about the forum module.  What/where is the blog_entry table?  Isn't the table in the forum module called forum_posts?  Isn't the "trick" here that one needs to know how to compose the url for the link into the forum module and the desired post?  How does one do that?  The links generated from within the forum module itself are internal to this moduleID number and such.

Also, www.dnnforums.com is suffering from a compilation error at the moment.  Anyone know how/where to report that problem?