Author |
Topic |
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 27 September 2005 : 09:43:09
|
*Scratches head* Obviously there's a typo I'm missing somewhere. A response.write on the redirect URI may reveal the problem.
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 September 2005 : 11:35:03
|
quote: Originally posted by Shaggy
*Scratches head* Obviously there's a typo I'm missing somewhere. A response.write on the redirect URI may reveal the problem.
I did it. Seemed ok to me. Will have to do it step by step, to find out where the redirect is ocurring.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 27 September 2005 : 11:36:30
|
Appreciate it, Rui Sorry to be bugging you with all these tests, really gotta get around to setting up a clean test forum meself
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 29 September 2005 : 06:46:07
|
Quick thought, Rui, are there any &s in the URI when you response.write it?
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 29 September 2005 : 07:02:57
|
Feck! Was hoping that'd be it!
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 02 January 2006 : 06:25:27
|
A quick bump for tomorrow so's I don't forget this.
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
Edited by - Shaggy on 02 January 2006 06:28:48 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 March 2006 : 10:17:18
|
Just resurrecting this one to see if anyone has any further thoughts on the problem we're encoutering above.
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 March 2006 : 11:06:07
|
Ok, found the answer. There was a small detail missing. Here is the line that needs changing:
response.redirect("topic.asp?"&ArchiveLink&strwhichpage&"TOPIC_ID="&Topic_ID&SearchLink&"&#"&LastPostReplyID)
In red that's what I added. I also removed the last two double quotes.
With the previous two fixes for intPageNumber and this one, it works with SQL Server.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 March 2006 : 20:18:58
|
Ok, here is the whole code:
if mypage=-1 then
strSql="SELECT REPLY_ID FROM "&strActivePrefix&"REPLY WHERE TOPIC_ID="&Topic_ID
if AdminAllowed=0 then
strSql=strSql&" AND (R_STATUS<"
if Moderation="Y" then strSql=strSql&"2" else strSql=strSql&"3"
strSql=strSql&" OR R_AUTHOR="&MemberID&")"
end if
strSql=strSql&" ORDER BY R_DATE ASC"
set rsReplies=server.createobject("ADODB.Recordset")
rsReplies.open strSql,my_Conn,adOpenStatic,adLockReadOnly,adCmdText
if not rsReplies.eof then
arrReplyData=rsReplies.getrows(adGetRowsRest)
iReplyCount=ubound(arrReplyData,2)
if len(request.querystring("REPLY_ID"))>0 then
LastPostReplyID=clng(request.querystring("REPLY_ID"))
for iReply=0 to iReplyCount
intReplyID=arrReplyData(0,iReply)
if LastPostReplyID=intReplyID then
intPageNumber=((iReply+1)\strPageSize)
if intPageNumber>clng(intPageNumber) then intPageNumber=clng(intPageNumber)+1
strwhichpage="whichpage="&intPageNumber&"&"
exit for
end if
next
else
LastPostReplyID=arrReplyData(0,iReplyCount)
intPageNumber=((iReplyCount+1)\strPageSize)
if intPageNumber>clng(intPageNumber) then intPageNumber=clng(intPageNumber)+1
strwhichpage="whichpage="&intPageNumber&"&"
end if
else
strWhichpage=""
end if
rsReplies.close
set rsReplies=nothing
my_Conn.close
set my_Conn=nothing
response.redirect("topic.asp?"&ArchiveLink&strwhichpage&"TOPIC_ID="&Topic_ID&SearchLink"&#"&LastPostReplyID)
response.end
end if
This code replaces lines#202-271 in an unchanged Snitz 3.4.05 topic.asp.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 08 March 2006 : 06:28:33
|
Gah! That bloody &! Gets me every time!
Good man, Rui, well spotted
Gonna do a bit more work on this over lunch, see if I can't try and get it to pick up last edited post without any additional queries. Don't think it's going to be possible, but worth a look any way.
< |
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
|
|
Topic |
|