[求助]为什么出现UPDATE语句语法错误?!!
<!--#include file="include/conn.asp"--><%
if session("id")="" or session("ac")="" or session("user")<>"1" then
response.write "<script language=JavaScript>" & chr(13) & "alert('您不具备此权限！');"&"window.location.href = 'index.asp'"&" </script>"
Response.End
end if
if request("rctype")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择人才类型！');" & "history.back()" & "</script>"
Response.End
end if
if request("pthua")="0" then
response.write "<script language=JavaScript>" & chr(13) & "alert('请选择普通话水平！');" & "history.back()" & "</script>"
Response.End
end if
if trim(request("kgzjl"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('个人工作经历不能为空！');" & "history.back()" & "</script>"
Response.End
end if
if isnumeric(request("gznum"))=false then
response.write "<script language=JavaScript>" & chr(13) & "alert('工作时间格式不正确！');" & "history.back()" & "</script>"
Response.End
end if
if trim(request("kothertc"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('工作能力不能为空！');" & "history.back()" & "</script>"
Response.End
end if
if trim(request("kmubiao"))="" then
response.write "<script language=JavaScript>" & chr(13) & "alert('职业目标不能为空！');" & "history.back()" & "</script>"
Response.End
end if
set rs=server.CreateObject("adodb.recordset")
sql="update in_user set rctype='"&request("rctype")&"',language='"&request("language")&"',lanlevel='"&request("lanlevel")&"',languages='"&request("languages")&"',lanlevels='"&request("lanlevels")&"',pthua='"&request("pthua")&"',computer='"&request("computer")&"',kgzjl='"&request("kgzjl")&"',gznum='"&request("gznum")&"',kothertc='"&request("kothertc")&"',kmubiao='"&request("kmubiao")&"' where id="&clng(session("id"))
rs.open sql,conn,3,3
set rs=nothing
set conn=nothing
response.redirect "psncontrol_3.asp"%>
为什么提示我错误!
错误类型：
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误。
/AllyJob/saveinfo_2.asp, 第 33 行
