Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Internationalization (v4-archive)
 Set query for Topics		  New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tamchu
Starting Member

Hong Kong
9 Posts
Posted - 28 August 2002 :  02:41:00  Show Profile  Reply with Quote
Hi all:

Can I setup the query(the order)for the topics in each forum, thanks

David


[moved by bozden on 03 October 2002]

<
Edited by - Deleted on 03 October 2002 21:00:05

bax
Junior Member

141 Posts
Posted - 28 August 2002 :  03:31:56  Show Profile
What do you want to set? I believe it currently sets them by time they were posted, most recent being towards the bottom.<
Go to Top of Page

tamchu
Starting Member

Hong Kong
9 Posts
Posted - 28 August 2002 :  04:55:49  Show Profile
Dear Bax:

I want to setup the topics order, as always the last one be on the top, but I want the topics to order by alphabet, is it possible?
thanks

David

quote:
Originally posted by bax

What do you want to set? I believe it currently sets them by time they were posted, most recent being towards the bottom.
<
Go to Top of Page

Deleted
deleted

4116 Posts
Posted - 28 August 2002 :  07:22:59  Show Profile
Assuming you are using v4b03.005:

find this line on forum.asp (near line 195)

strSql = strSql & " ORDER BY " & strActivePrefix & "TOPICS.T_LAST_POST DESC "


and change it to

strSql = strSql & " ORDER BY " & strActivePrefix & "TOPICS.T_SUBJECT ASC "


Please try it...
<
Stop the WAR!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07