﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>InstantASP Community Forums / InstantForum.NET 4.x / User / App Integration / Community Support  / Poll Integration / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>InstantASP Community Forums</description><link>http://community.instantasp.co.uk/</link><webMaster>sales@instantasp.co.uk</webMaster><lastBuildDate>Fri, 21 Nov 2008 21:49:59 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Poll Integration</title><link>http://community.instantasp.co.uk/Topic13916-61-1.aspx</link><description>Hi WAL&lt;br&gt;Try this one on for size!!&lt;br&gt;&lt;br&gt;CREATE PROCEDURE [dbo].[Mac_if_sp_SelectmostRecentTopics]&lt;br&gt;&lt;br&gt;AS&lt;br&gt;&lt;br&gt;    BEGIN&lt;br&gt;    SELECT TOP 5 InstantForum_Topics.TopicID, InstantForum_Topics.Title, InstantForum_Topics.LastPosterDate, InstantForum_Topics.LastPosterUsername, InstantForum_Topics.LastPosterUserID FROM InstantForum_Topic (nolock)&lt;br&gt;    WHERE InstantForum_Topics.parentID = 0 ORDER BY InstantForum_Topic.LastPosterDate DESC&lt;br&gt;END&lt;br&gt;   &lt;br&gt;    RETURN&lt;br&gt;&lt;br&gt;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.&lt;br&gt;&lt;br&gt;just chuck it into a collection, loop through the collection, babam.</description><pubDate>Fri, 16 May 2008 00:16:50 GMT</pubDate><dc:creator>Mac d'Mac</dc:creator></item><item><title>Poll Integration</title><link>http://community.instantasp.co.uk/Topic13916-61-1.aspx</link><description>Hi,&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;Roy</description><pubDate>Wed, 14 May 2008 11:43:11 GMT</pubDate><dc:creator>WAL</dc:creator></item></channel></rss>