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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net