General Discussion - forum posts order

Print Page | Close Window

forum posts order

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20964
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: forum posts order

Posted By: drgl
Subject: forum posts order
Date Posted: 09 August 2006 at 1:37pm

Is ther any way to make the posts in the forum go in alphabetical order rather than chronological?

Replies:

Posted By: Bluefrog
Date Posted: 09 August 2006 at 4:50pm

Look for an "ORDER BY" and change it in the code. Should work ok.

-------------
http://renegademinds.com/" rel="nofollow - Renegade Minds - Guitar Software http://renegademinds.com/Default.aspx?tabid=65" rel="nofollow - Slow Down Music

Posted By: drgl
Date Posted: 14 August 2006 at 10:20am

Hi,am i looking for an ASP page with that name?? Thanks

Posted By: Mart
Date Posted: 14 August 2006 at 10:28am

No, you're looking for forum_topics.asp, and changing the SQL that grabs the topic list to ORDER BY post name instead.

And you've posted in the wrong forum.

Posted By: drgl
Date Posted: 14 August 2006 at 1:06pm

sorry about the wrong forum but can you explain futher on how to do this?

Posted By: iSec
Date Posted: 14 August 2006 at 9:59pm

You can post a request for it in the Modifications forum.

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Posted By: drgl
Date Posted: 16 August 2006 at 9:08am

No answer in mods forum. i opened the forum_topics.asp in a text editor and found this :-

strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date ASC;"

However i haven't a clue what to put instead of message date!! Can anyone help?Thanks

Posted By: drgl
Date Posted: 16 August 2006 at 9:45am

Ok,had a play and it worked!! I changed it to :-

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

Will this apply to all forum posts?

Posted By: drgl
Date Posted: 17 August 2006 at 12:39pm

that worked on version 7-any ideas on version 8? Now i've upgraded i can't get it to work.