Does TblTopic.Last_entry_date work at all ?
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=25436
Printed Date: 03 April 2026 at 8:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Does TblTopic.Last_entry_date work at all ?
Posted By: Sundsdal
Subject: Does TblTopic.Last_entry_date work at all ?
Date Posted: 12 March 2008 at 1:06am
Hi
I want (like many many others) to have the latest postings on my site.
When i run this :
SELECT TOP 25 TblTopic.Forum_ID, TblTopic.Topic_ID, TblTopic.Subject, TblTopic.Last_entry_date FROM TblTopic WHERE TblTopic.Forum_ID=1 ORDER BY TblTopic.Last_entry_date DESC
It seems like when i order by Last_entry_date, it only has the startdato for the topic... and not the date/time for the latest entry on the specific topic.
I want it distinct (and have tried that.... without any luck)
Or... does anyone have a solution on the "latest topic post" issue ?
|
Replies:
Posted By: Sundsdal
Date Posted: 16 March 2008 at 6:33pm
Can someone check if your database is up-to-date ind the "TblTopic.Last_entry_date" field ?
My field does not update this field.... its only updated when someone post a new topic, and not when people reply on a topic.
|
Posted By: WebWiz-Bruce
Date Posted: 17 March 2008 at 5:29pm
The Last_entry_date field should be updated everytime someone posts, if yours is not it could be a corrupted file. Try reuploading the original files again.
In the extras folder there is a file containing code which will place the last 10 posts into another web page on your site or another web site. It uses the RSS Feed to do this.
-------------
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: Sundsdal
Date Posted: 17 March 2008 at 8:01pm
Bruce: Thanks for the answers...
Which files should i upload again ? Its it only : new_post.asp ? I will not overwrite all my files coz i have made som small changes, to fit my layout. (i have the paid version)
The RSS feed does not show the output i want. I want the latest topics with new threads in. (distinct)
|
Posted By: Sundsdal
Date Posted: 29 March 2008 at 5:03pm
Where are the Last_entry_date field updated ?
its not located in the new_post.asp
|
Posted By: WebWiz-Bruce
Date Posted: 31 March 2008 at 11:25am
A function is called in this file to update the forum statistics which does this update.
-------------
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
|
|