|
|
|
Forum Newbie
Group: Forum Members
Last Login: 14/05/2008 14:32:12
Posts: 2,
Visits: 15
|
|
| Hi, Is it possible to pull the poll functionality out to use as a control on a page in a website? We'd want to maintain full functionality i.e. people can vote and only see the results if they have already voted. EDIT:: Acctualy - in addition to this - is it possible to pull through the latest forum posts on the site i.e. list the last 5 posts with links to the thread. Cheers, Roy
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 09/06/2008 17:35:47
Posts: 11,
Visits: 61
|
|
Hi WAL
Try this one on for size!!
CREATE PROCEDURE [dbo].[Mac_if_sp_SelectmostRecentTopics]
AS
BEGIN
SELECT TOP 5 InstantForum_Topics.TopicID, InstantForum_Topics.Title, InstantForum_Topics.LastPosterDate, InstantForum_Topics.LastPosterUsername, InstantForum_Topics.LastPosterUserID FROM InstantForum_Topic (nolock)
WHERE InstantForum_Topics.parentID = 0 ORDER BY InstantForum_Topic.LastPosterDate DESC
END
RETURN
It will return the TopicID - to link to the correct topic, the title of the latest topic, the time and date of the lastest posting on that topic, the user and then the userid to link to the correct user's profile.
just chuck it into a collection, loop through the collection, babam.
Entertainment.fm, Nightclubs, Restaurants, Hotels, Bars, Forums, Chat Rooms, Polls - Your playground on the internet!!
|
|
|
|