求助。。。
677 2004-12-20 12:04:18 问题如下:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '客户编号=' 中。
/guest/del.asp,行 19
代码:
<%@ LANGUAGE="VBSCRIPT" %>
<%
txt1 = Request.FORM("txt1")
txt2 = Request.FORM("txt2")
txt3 = Request.FORM("txt3")
txt4 = Request.FORM("txt4")
txt5 = Request.FORM("txt5")
txt6 = Request.FORM("txt6")
txt7 = Request.FORM("txt7")
txt8 = Request.FORM("txt8")
%>
<%
Dim Conn
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
Dbpath = Server.MapPath("customer.mdb")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Dbpath
Dim SQL
SQL = "DELETE * FROM 客户 WHERE 客户编号=" & ID
Conn.Execute SQL
Conn.Close
Set Conn = Nothing
Response. Write "<html><body><center><font size=3>编号为" & ID
Response. Write "的记录已经成功删除!</font></body></html>"
Response.Redirect "viewdatabase.asp"
Response.End
%>