Newest post first - نوشته شده در (853 Views)
New Member
Swn-Y-Mor
مطلب: 90
90
Hi,
Is it possible to reverse the posting order whereby newest post shows first, to save scrolling to bottom of page?<
 پیش‌فرض مرتب‌سازی برای تاریخ DESC به معنی جدیدترین است  
 تعداد در صفحه 
نوشته شده در
Average Member
taropatch
مطلب: 741
741
Check snitzbitz.com and see this post http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=42533<
نوشته شده در
New Member
Swn-Y-Mor
مطلب: 90
90
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.<
نوشته شده در
Starting Member
achaudhary
مطلب: 7
7
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



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.
<
نوشته شده در
کاربر قفل شده
laser
مطلب: 3859
3859
You will get the opening post first because of this code :

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 :

Code:

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

- Change it to this :

Code:

			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.<
نوشته شده در
Senior Member
Astralis
مطلب: 1218
1218
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?<
نوشته شده در
Senior Member
Astralis
مطلب: 1218
1218
Would a moderator please move this to one of the Mod forums? I think it fits there.<
نوشته شده در
Senior Member
Astralis
مطلب: 1218
1218
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:
Code:

	if mypage = 1 then 
Call GetFirst()
end if
Then find this code:
Code:

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

Then replace with this code:
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.<
نوشته شده در
Support Moderator
pdrg
مطلب: 2897
2897
topic moved here from general help, swn-y-mor emailed to let him know :)<
نوشته شده در
Snitz Forums Admin
ruirib
مطلب: 26364
26364
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 smile.<
 
شما باید یک متن وارد کنید