Author |
Topic |
|
Swn-Y-Mor
New Member
90 Posts |
Posted - 14 February 2005 : 16:31:50
|
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 |
|
Swn-Y-Mor
New Member
90 Posts |
Posted - 14 February 2005 : 18:04:56
|
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.< |
|
|
achaudhary
Starting Member
7 Posts |
Posted - 14 September 2005 : 16:10:27
|
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.
< |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 14 September 2005 : 17:31:14
|
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.< |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 21 September 2005 : 16:24:32
|
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 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 21 September 2005 : 23:24:53
|
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 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 22 September 2005 : 01:38:09
|
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 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 22 September 2005 : 03:36:44
|
topic moved here from general help, swn-y-mor emailed to let him know :)< |
Edited by - pdrg on 22 September 2005 03:40:06 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 September 2005 : 05:55:21
|
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 |
|
|
|
Topic |
|