Thanks for the reply Huwr!
Are you saying that the field names and field properties in FORUM_A_TOPICS and FORUM_TOPICS have to be identical? Same going for FORUM_A_REPLY and FORUM_REPLY?
This is the area of code the error above is referencing:
drs.Open strsql, my_conn, 3, 3
'set drs = my_conn.execute(strsql)
'#### Archive the Replies
if drs.eof then
response.write("<br><center><font face=" & strDefaultFontFace & " size=" & strFooterFontSize & ">No replies were archived, none found</center><br>")
else
i = 0
do until drs.eof
strsqlvalues = "" & drs("CAT_ID") & ", " & drs("FORUM_ID") & ", " & drs("TOPIC_ID") & ", " & drs("REPLY_ID")
strsqlvalues = strsqlvalues & ", " & drs("R_AUTHOR") & ", '" & chkstring(drs("R_MESSAGE"),"archive")
strsqlvalues = strsqlvalues & "', '" & drs("R_DATE") & "', '" & drs("R_IP") & "'" & ", " & drs("R_SIG") & ", " & drs("R_STATUS") & ""
strsql = "INSERT INTO " & strArchiveTablePrefix & "REPLY (CAT_ID, FORUM_ID, TOPIC_ID, REPLY_ID, R_AUTHOR, R_MESSAGE, R_DATE, R_IP, R_SIG, R_STATUS)"
strsql = strsql & " VALUES (" & strsqlvalues & ")"
response.write "<font face=" & strDefaultFontFace & " size=" & strFooterFontSize & ">.</font>"
518 my_conn.execute(strsql)
I have two Signature MODs installed. One is the Preview Signatures MOD, and the other is the Dynamic Signatures MOD. Does this effect the R_SIG field adversely?
The code below lists 10 fields, yet I have 12 fields in my FORUM_A_REPLY table and 13 fields in my FORUM_REPLY table.
514 strsql = "INSERT INTO " & strArchiveTablePrefix & "REPLY (CAT_ID, FORUM_ID, TOPIC_ID, REPLY_ID, R_AUTHOR, R_MESSAGE, R_DATE, R_IP, R_SIG, R_STATUS)"
Thanks for the vote of confidence, richfed! 
Cheers,
Etymon
Topic Locked
Posted - 15 September 2002 : 03:15:56
