Web Wiz Forums - Recent Posts SELECT command

Print Page | Close Window

Recent Posts SELECT command

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30317
Printed Date: 31 March 2026 at 5:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Recent Posts SELECT command

Posted By: sean3838
Subject: Recent Posts SELECT command
Date Posted: 11 May 2012 at 1:32am

I've been messing around trying to come up with a SQL select statement to get the subject, forum name, post date (from subject) and the url for the subject but I haven't been able to come up with one.

Any help would be awesome!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 11 May 2012 at 12:43pm

If you are trying to include the latest posts in another page then have a look at the 'recent_forum_posts.asp' file in the 'extras' folder.

The ASP code can be updated with the URL to your forums RSS Feed and then included in another page to display the latest forum posts from your forum.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: sean3838
Date Posted: 18 May 2012 at 8:04pm

Okay, I'm going to take a different approach. My site is built in asp.net and it seems I'd have to convert the asp page to a .net control which I don't want to do. What I want to do is just write the recent posts to a .txt file. I can then just read in the .txt file in my asp.net code behind.

So what would be the ASP code to write the recent posts to a .txt file?

Posted By: sean3838
Date Posted: 18 May 2012 at 10:02pm

Never mind I got it to work, just had to get rid of the SET keywords and wrap the arguments in parentheses.