ASP网站中出现的问题,请大侠解答
Microsoft JET Database Engine 错误 '80040e14' 语法错误 (操作符丢失) 在查询表达式 '1','11','11')' 中。
/2626/CN_AdmProduct/CategoryEdit.asp,行 99
代码如下:(99行已经用红色标记)
sSql=""
If act <> "3" Then
If nID ="0" Then
sSql="insert into " & tableName2 & "(name,ParentID,sortIndex,keyTitle,keyKeywords,keyDescription,fileName) values('" & txtName & "'," & numParentID & "," & numSortIndex & ",'" & strTitle & "'," & strKeywords & "','" & strDescription
sSQL=sSQL & "','" & strFileName & "')"
else
sSql="update " & tableName2 & " set [name]='" & txtName & "',ParentID=" & numParentID & ",sortIndex=" & numSortIndex
sSql=sSql & ",keyTitle='" & strTitle & "',keyKeywords='" & strKeywords & "',keyDescription='" & strDescription
sSql=sSQL & "',fileName='" & strFileName & "' where id=" & nID
end If
'response.write ssql
'response.end
conn.execute(sSql)
Response.Write("<script>window.open('Category.asp', 'leftFramex');window.open('info.asp', 'mainFramex');alert('操作成功.');</script>")
End If
End If
sSql=""
If act = "3" Then