Web Wiz Forums - Last_entry_date in tblTopic not updating

Print Page | Close Window

Last_entry_date in tblTopic not updating

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=27998
Printed Date: 02 April 2026 at 8:05am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Last_entry_date in tblTopic not updating

Posted By: hummelmose
Subject: Last_entry_date in tblTopic not updating
Date Posted: 05 November 2009 at 7:32pm

Hi there.

I've just upgraded our forum to 9.63. And I've written som user controls which looks through the database on latest topics.

But it seems that the field Last_entry_date is no longer updated in tblTopic.

why ?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 November 2009 at 12:17pm

This field is no longer used as it is not required anymore due to new improved and optimised code that means that this data can be returned in a much better and faster way in the latest version.

The field Last_entry_date can be deleted form your database as it is no longer required.

Instead two new fileds are used Start_Thread_ID and Last_Thread_ID by linking the tblTopic table to the tblThread table using the Last_Thread_ID you would be able to get the date of the last post.

-------------
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: hummelmose
Date Posted: 06 November 2009 at 12:23pm

Thanks for your answer.

I've used it from thread allready :-)

-------------
Jens Hummelmose