Print Page | Close Window

Sort Topics Alphabetically

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=14646
Printed Date: 12 April 2026 at 7:19pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Sort Topics Alphabetically
Posted By: amclendon
Subject: Sort Topics Alphabetically
Date Posted: 11 April 2005 at 8:01pm
I'm using the forum to post information and documentation so I want to sort alphabetically not by date.  Would it be possible to change the code somewhere to make this happen?
 
Thanks,
Aaron



Replies:
Posted By: dj air
Date Posted: 11 April 2005 at 8:06pm
firstly congratulations on having a great first name...

lol (im also Aaron)

anyway to your question

yes it is possible if you are using access then all you have to do is look for the section/query that brings in the topics and change where it says ORDERBY tblTopics.post_date (example)

to Subject ASC;

changing post_date only.


if SQL server you need to edit the store procedure that is on the SQL server... but it is the same as above but there instead.


Posted By: amclendon
Date Posted: 11 April 2005 at 8:32pm
Thanks Aaron.  It worked great. 
 
I found it in forum_topics.asp in line 340 (version 7.9) and changed strDbTable & "Topic.Last_entry_date DESC;" to strDbTable & "Topic.Subject ASC;"
 
You're the man.  Thanks for the quick reply.
 
Aaron



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