Web Wiz Support and Community Forums : Sort Topics Alphabetically https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:21:55 +0000 Mon, 11 Apr 2005 20:32:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14646 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Sort Topics Alphabetically : Thanks Aaron. It worked great....]]> https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80974.html#80974 Author: amclendon
Subject: 14646
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
]]> Mon, 11 Apr 2005 20:32:06 +0000 https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80974.html#80974 <![CDATA[Sort Topics Alphabetically : firstly congratulations on having...]]> https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80971.html#80971 Author: dj air
Subject: 14646
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 islook for the section/query that brings in the topics and change whereit 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.
]]> Mon, 11 Apr 2005 20:06:26 +0000 https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80971.html#80971 <![CDATA[Sort Topics Alphabetically : I&#039;m using the forum to post...]]> https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80970.html#80970 Author: amclendon
Subject: 14646
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
]]> Mon, 11 Apr 2005 20:01:42 +0000 https://forums.webwiz.net/sort-topics-alphabetically_topic14646_post80970.html#80970