语句不能执行?
update x2 set bt='测试 ',bz='no messge',ggrq='2005-04-06',gh='123',xu='55',lg='具体信息'where pid='55'
这句语句直接在ACCESS里可执行,但在ASP里即出现以下错误提示,如何解决呢:
技术信息(用于支持人员)
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 操作必须使用一个可更新的查询。
/xzsp/edit_exe.asp, 第 19 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
网页:
POST 194 ??? /xzsp/edit_exe.asp
POST Data:
jm=55&name=6&xu=55&ggrq=2005-04-06&bt=%B2%E2%CA%D4%BE%D6+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++&lg=%BE%DF%CC%E5%D0%C5%CF%A2&bz=no+messge&Submit=%CC%E1%BD%BB
以下是ASP原代码:
<%gh=Request.form("gh")%>
<%xu=Request.form("xu")%>
<%ggrq=Request.form("ggrq")%>
<%bt=Request.form("bt")%>
<%lg=Request.form("lg")%>
<%bz=Request.form("bz")%>
<%pid=Request.form("jm")%>
<%
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=" & Server.MapPath("/xzsp/db.mdb")
conn.Open Strconn
%>
<%str1="update x2 set bt='"&bt&"',bz='"&bz&"',ggrq='"&ggrq&"',gh='"&gh&"',xu='"&xu&"',lg='"&lg&"'where pid='"&pid&"'"%>
<%=str1%>
<%conn.execute(str1)%>