|
aviv
Junior Member
474 Posts |
 Posted - 06 May 2002 : 11:45:00
|
i'm getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/test33/post_info.asp, line 882
---------------------
the red is line 882:
' DEM --> End of Code added
strSql = strSql & ", " & Request.Form("strMessageIcon")
strSql = strSql & ", " & "'" & txtMessage & "'"
strSql = strSql & ")"
my_Conn.Execute (strSql)
' DEM --> Do not update totals on topics and forums database if post is moderated...Added if and end if
if Moderation = "No" then
'## Forum_SQL - Update Last Post and count
strSql = "UPDATE " & strActivePrefix & "TOPICS "
strSql = strSql & " SET T_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
strSql = strSql & ", T_REPLIES = T_REPLIES + 1 "
strSql = strSql & ", T_LAST_POST_AUTHOR = " & rs("MEMBER_ID")
if Request.Form("lock") = 1 then
strSql = strSql & ", T_STATUS = 0 "
end if
strSql = strSql & " WHERE TOPIC_ID = " & Topic_ID
-------------------------
ThanX
Aviv
|
|
Topic Locked
