UPDATE 语句的语法异常

UPDATE 语句的语法错误。
updateshow.asp:

<%@LANGUAGE= "VBScript " codepage= "936 "%>
<%if session( "admin ") <> " " then%>

<%
set rs=server.createobject( "adodb.recordset ")
id=Request.QueryString( "id ")
sql= "select * from main where id= "&id
rs.open sql,conn,2,3
%>
<html>
<head>
<title> 留言本-填写留言 </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
</head>
<body>
<form action= "update.asp " method= "post " name= "add ">
<input type= "hidden " name= "id " value= " <%=Request.QueryString( "id ")%> "/>
<table width= "450 " border= "0 " align= "center " cellpadding= "2 " cellspacing= "0 ">
<tr>
<td height= "40 " colspan= "2 " align= "center "> <span class= "text3 "> <strong> 留言本-填写留言 </strong> </span> </td>
</tr>
<tr>
<td width= "124 "> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 姓名 </p> </td>
<td width= "318 "> <input name= "user " type= "text " id= "user " value= " <%=rs( "user ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> QQ号 </p> </td>
<td> <input name= "qq " type= "text " value= " <%=rs( "qq ")%> "> </td>
</tr>
<tr>
<td> <P style= "MARGIN-TOP: 2px; MARGIN-LEFT: 80px "> 邮件 </p> </td>
<td> <input name= "email " type= "text " value= " <%=rs( "email ")%> "> </td>
</tr>
<tr>
<td valign= "top "> <P style= "MARGIN-TOP: 5px; MARGIN-LEFT: 80px "> 内容 </p> </td>
<td> <textarea name= "content " cols= "30 " rows= "5 "> <%=rs( "content ")%>
</textarea> </td>
</tr>
<tr align= "center ">

<td colspan= "2 "> <input type= "submit " name= "Submit " value= "留言 ">
<input type= "reset " name= "Submit " value= "重填 "> </td>
</tr>
</table>
</form>
</body>
</html>
<%rs.close
set rs=nothing
conn.close
set conn=nothing

else
response.Redirect( "admin.asp ")
end if%>

=================
update.asp:

<%@LANGUAGE= "VBScript " codepage= "936 "%>
<%if session( "admin ") <> " " then%>

<%
id=Request.form( "id ")
user=Request.form( "user ")
qq=Request.form( "qq ")
email=Request.form( "email ")
content=Request.form( "content ")
sql= "update main set user= ' "& user & " ',qq= ' "& qq & " ',email= ' "&email & " ',content= ' "& content & " ' where id= "&id
response.write sql
conn.execute(sql)
conn.close
set conn=nothing
%>
<html>
<head>
<title> 修改成功！ </title>
<link href= "style.css " rel= "stylesheet " type= "text/css ">
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<style type= "text/css ">

</style>
<meta http-equiv= "refresh " content= "10;URL=mymanage.asp ">
</head>
<body>
<div align= "center "> 更新成功，2秒钟后自动跳转到 <a href= "mymanage.asp "> 管理员页面 </a> </div>
</body>
</html>
<%
else
response.Redirect( "admin.asp ")
end if%>

==========
错误类型：
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误。
/guestbook1/guestbook/update.asp, 第 12 行

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon)

网页：
POST 93 ??? /guestbook1/guestbook/update.asp

POST Data:
id=4&user=dd1&qq=22&email=2121@1212&content=213132eqwrasfafas%0D%0A++++++&Submit=%C1%F4%D1%D4

===========
问题出在哪里?怎样解决更新问题呢?

[解决办法]
sql= "update main set user= ' "& user & " ',qq= ' "& qq & " ',email= ' "&email & " ',content= ' "& content & " ' where id= "&id 这句错误，修改为

sql= "update main set (user,qq,email,content) value ( ' "& user & " ', ' "& qq & " ', ' "&email & " ', ' "& content & " ') where id= "&id

[解决办法]
在你的事件探测器里面监视一下看你的语句执行没有。。。。
[解决办法]
sql= "update main set user= ' "& user & " ',qq= ' "& qq & " ',email= ' "&email & " ',content= ' "& content & " ' where id= "&id

这句没错，请检查数据库，除ID外，其它字段是不是都是字符型或备注型。
[解决办法]
sql= "update main set [user]= ' "& user & " ',qq= ' "& qq & " ',email= ' "&email & " ',content= ' "& content & " ' where id= "&id
[解决办法]
你的sql语句应该没错，检查其他地方，比如request过来的值。
[解决办法]
main表里有几个字段？各是什么类型？

[解决办法]
同意wcwtitxu(痞子) 的方法,因为user是Sql系统关键字~~应该用[]引用

sql= "update main set [user]= ' "& user & " ',qq= ' "& qq & " ',email= ' "&email & " ',content= ' "& content & " ' where id= "&id

UPDATE 语句的语法异常

热点推荐