高手帮忙!
dim conn,dbfile,ps,user,id,rs,sql
user=request.form("user")
ps=request.form("ps")
id=request("id")
sql="select * from lyg where id="&id
dbfile=server.mappath("gonggao.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&dbfile
set rs=server.CreateObject("adodb.recordset")
if user="wfx" and ps="1234" then
rs.open sql,conn,3,3
rs.delete
rs.update
Response.Write("删除成功!2秒自动返回")
Response.AddHeader "refresh","2;URL=ly.asp"
else
response.write"可能用户名错或者密码错,或许你没权限。请返回!2秒自动返回"
Response.AddHeader "refresh","2;URL=ly.asp"
end if
程序报:加横线的行
语法错误 (操作符丢失) 在查询表达式 'id==64'