数据记录无法更新!!
article_editsave1.asp代码如下:
<!--#include file= "conn.asp "-->
<%
set rs=server.createobject( "adodb.recordset ")
sql= "select * from [top] where id= "&request( "id ")
rs.open sql,conn,1,3
rs( "name ")=request.form( "name ")
rs( "tel ")=request.form( "tel ")
rs( "download ")=request.form( "download ")
rs( "pic ")=request.form( "pic ")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "edit.asp "
response.write " <SCRIPT language=JavaScript> alert( '恭喜您!修改成功! '); "
response.write "window.document.location.href= 'article_edit.asp '; </SCRIPT> "
%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'id= ' 中。
/news/article_editsave1.asp, 第 5 行
请会的朋友指教..谢谢!
------解决方案-------------------- <form action= "article_editsave1.asp?id= <%=request( "id ")%> " method= "post " onSubmit= "return Juge(this) " name= "myform ">