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 MOD-Group
 MOD Add-On Forum (W/Code)
 Newest post first
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Swn-Y-Mor
New Member

90 Posts

Posted - 14 February 2005 :  16:31:50  Show Profile  Reply with Quote
Hi,
Is it possible to reverse the posting order whereby newest post shows first, to save scrolling to bottom of page?<

Edited by - pdrg on 22 September 2005 03:38:16

taropatch
Average Member

USA
741 Posts

Posted - 14 February 2005 :  16:38:21  Show Profile  Reply with Quote
Check snitzbitz.com and see this post http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=42533<
Go to Top of Page

Swn-Y-Mor
New Member

90 Posts

Posted - 14 February 2005 :  18:04:56  Show Profile  Reply with Quote
I tried your suggestion, but it isn't exactly what I wanted.
I want to sort the Topic.asp pages DESC

should be line 331:
strSql4 = " ORDER BY R.R_DATE ASC"

change to

should be line 331:
strSql4 = " ORDER BY R.R_DATE DESC"

but the initial post is first then the last - which is a bit confusing.<
Go to Top of Page

achaudhary
Starting Member

7 Posts

Posted - 14 September 2005 :  16:10:27  Show Profile  Reply with Quote
Swn-Y-Mor
Did you find a solution to this problem? I made the exact same change to the code before searching for it on the forum. I am getting the same format. The newest post first and then the first post and so on. Please let me know if you fond some answer to this problem.
Thanks



quote:
Originally posted by Swn-Y-Mor

I tried your suggestion, but it isn't exactly what I wanted.
I want to sort the Topic.asp pages DESC

should be line 331:
strSql4 = " ORDER BY R.R_DATE ASC"

change to

should be line 331:
strSql4 = " ORDER BY R.R_DATE DESC"

but the initial post is first then the last - which is a bit confusing.

<
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts

Posted - 14 September 2005 :  17:31:14  Show Profile  Reply with Quote
You will get the opening post first because of this code :


	if mypage = 1 then 
		Call GetFirst() 
	end if


You need to move it, but I'm not sure where, I would guess ...

- delete the code (above)
- find this code :


			if intI = 2 then 
				intI = 0
			end if
		next
	end if


- Change it to this :


			if intI = 2 then 
				intI = 0
			end if
		next
		if mypage = maxpages then 
			Call GetFirst() 
		end if
	end if


That MIGHT work, but I didn't test it.<
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 21 September 2005 :  16:24:32  Show Profile  Send Astralis a Yahoo! Message  Reply with Quote
That does not work because if you have more than one page, it will put the first post on the bottom of the first page only. I'm not sure how to get around that. Any ideas?<

Edited by - Astralis on 22 September 2005 01:40:38
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 21 September 2005 :  23:24:53  Show Profile  Send Astralis a Yahoo! Message  Reply with Quote
Would a moderator please move this to one of the Mod forums? I think it fits there.<

Edited by - Astralis on 22 September 2005 01:40:54
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts

Posted - 22 September 2005 :  01:38:09  Show Profile  Send Astralis a Yahoo! Message  Reply with Quote
This hasn't been tested thoroughly, but I replaced the code with this and it seems to work:

As the poster above said, first remove this code:

	if mypage = 1 then 
		Call GetFirst() 
	end if

Then find this code:

			if intI = 2 then 
				intI = 0
			end if
		next
	end if


Then replace with this code:

			if intI = 2 then 
				intI = 0
			end if
		next
       if mypage = maxpages then 
		Call GetFirst() 
	end if
	end if
	if maxpages = "" then
                Call GetFirst()
        end if

Please post your comments. Although this is working for now, I think there is a lot of room here for mistakes.<

Edited by - Astralis on 22 September 2005 01:57:35
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 22 September 2005 :  03:36:44  Show Profile  Send pdrg a Yahoo! Message  Reply with Quote
topic moved here from general help, swn-y-mor emailed to let him know :)<

Edited by - pdrg on 22 September 2005 03:40:06
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 22 September 2005 :  05:55:21  Show Profile  Send ruirib a Yahoo! Message  Reply with Quote
quote:
Originally posted by pdrg

topic moved here from general help, swn-y-mor emailed to let him know :)


Email is sent automatically when the post is moved, so no need for you to send another email .<


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07