Print Page | Close Window

Order of msgs being posted

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=1591
Printed Date: 30 March 2026 at 3:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Order of msgs being posted
Posted By: AlexKGB
Subject: Order of msgs being posted
Date Posted: 04 April 2003 at 1:46am

Hi,

I've already asked this some time ago, but can't find this topic nomore.

How can I change order of msgs being posted? Last posted is on page 4. I'd like it on page 1, so that new posts are 1st seen. After i post a msg, I want to be sent to 1st page, not last.

Btw, regarding cookies topic (last week). I reinstalled WIN.

thx,

Alex




Replies:
Posted By: MadDog
Date Posted: 04 April 2003 at 2:34am

Hey,

Open up 'forum_topics.asp'

At (or around) line 334 there is this:

strSQL = strSQL & "ORDER BY " & strDbTable & "Topic.Priority DESC, " & strDbTable & "Topic.Last_entry_date DESC;"

Replace with:

strSQL = strSQL & "ORDER BY " & strDbTable & "Topic.Priority DESC, " & strDbTable & "Topic.Last_entry_date ASC;"

The change is in bold. This is for access only.
If you are running SQL let me know and ill tell you how to change the stored procedure.

Hope this works



-------------
http://www.iportalx.net" rel="nofollow">



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