Order of msgs being posted

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
AlexKGB Members Profile Find Members Posts Newbie Joined: 20 March 2003 Status: Offline Points: 8	Post Options Post Reply Quote AlexKGB Report Post Thanks(0) Quote Reply Topic: Order of msgs being posted 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

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.