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
|
|