| Author |
 Topic  |
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
 Posted - 07 April 2002 : 11:15:28
|
I am trying to install the Report to moderator MOD
but keep getting this error
Type mismatch: 'rs'
/forum99/topic.asp, line 640
Line 640 is as follows
<font size="1"><a href='ComplainToModerator.asp?IsTopic=0&action=REPORT&REPLY_ID=<% =rs("REPLY_ID") %>&TOPIC_ID=<% =Request.QueryString("TOPIC_ID") %>&FORUM_ID=<% =Request.QueryString("FORUM_ID") %>&CAT_ID=<% =Request.QueryString("CAT_ID")%>&ReporterID=<%=rs("MEMBER_ID")%>&TOPIC_TITLE=<%=Request.QueryString("Topic_Title")%>'>Report To Moderator</a></font>
I am using a SQL DB.
 |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 07 April 2002 : 11:45:00
|
I don't see anything wrong with this, but you're posting in the wrong forum. Report to Moderator is not a feature in the standard forums, it's a MOD. Next time please post your MOD installation problems in the appropriate forum.
Thank you 
http://www.frutzle.com
Snitz Exchange | Do's and Dont's |
 |
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 07 April 2002 : 18:48:23
|
I keep getting this Type mismatch: 'rs' error.
Has anyone any ideas why ?
|
|
|
|
Image
Average Member
Canada
574 Posts |
Posted - 07 April 2002 : 18:58:01
|
Around Line Line 640 :
change
rs("REPLY_ID")
for
rsReplies("REPLY_ID")
and
rs("MEMBER_ID")
for
rsReplies("MEMBER_ID")
Around Line 920:
change
rs("MEMBER_ID")
for
rsTopic("MEMBER_ID")
image
~ Image Forum 2001 ~
Edited by - Image on 07 April 2002 19:07:16 |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 19:05:41
|
easy does it. maybe someone should make a little FAQ on this; that there are two main parts in topic.asp, namely the rsTopic part and the rsReplies part.
just a tip...
Crash's Site | Crash is from 
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 08 April 2002 : 04:51:17
|
Thank you Gents
A little new to all this 
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 08 April 2002 : 13:30:24
|
I have installed the MOD and get the 'Report to MOD' message at the bottom of both topics and replies but when I post a complaint i get this message.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/forum99/ComplainToModerator.asp, line 111
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 18 bytes to /forum99/ComplainToModerator.asp
POST Data:
msg=&Submit=Submit
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 08 April 2002 : 16:06:22
|
Here is a link to the ComplainToModerator.asp file in text format http://80.4.80.113/forum99/ComplainToModerator.txt
I keep getting this error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/forum99/ComplainToModerator.asp, line 111
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 33 bytes to /forum99/ComplainToModerator.asp
POST Data:
msg=%5B%5B%5D%0D%0A&Submit=Submit
Any help on this would be appreciated.
Thanks
Edited by - Syko BA on 08 April 2002 19:27:22 |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 09 April 2002 : 00:53:26
|
perhaps you could post that line
Crash's Site | Crash is from
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 09 April 2002 : 02:54:30
|
no. i don't want the complete code. just the line that gives the error
Crash's Site | Crash is from
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 09 April 2002 : 13:10:24
|
Crash
Thease are the lines that are causing the problem.
SQL = SQL & " VALUES(" & ForumID & ", " & TopicID & ", " & CatID & ", '" & message & "', " & ReporterID & ", " & IsTopic & ", " & ReplyID & ", " & 0 & ")"
'Response.Write SQL
my_Conn.execute SQL
Response.Write "<center><b>Thank you for keeping this forum clean....... <br><br> redirection to forum page" & _
"<meta http-equiv='refresh' content='3;url=default.asp'>"
The line in Red is line number 111 in file ComplainToModerator.asp
Cheers
|
|
|
|
Syko BA
Junior Member
United Kingdom
257 Posts |
Posted - 10 April 2002 : 06:34:13
|
Can anyone help me with this error ?
If you goto http://80.4.80.113/forum99/topic.asp?TOPIC_ID=29 and try 'Alert Moderator' you will after entering your message see an error.
I have no idea why this is occuring.
Thank you
|
|
|
| |
Topic |
|
Topic Locked
