lol诺手怎么打提莫:Microsoft JET Database Engine (0x80040E10)

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 19:54:14
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
</head>

<%dbpath=server.mappath("data/guestbook.mdb")
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=" & dbpath
%>

<%a=request.QueryString("id")%>
<%response.write(a) %>
<%
set rs=server.CreateObject("ADODB.recordset")
sql="select * from pic where pic.id=a "
rs.open sql,conn,1,1
%>
</html>

rs.open sql,conn,1,1------------------出错行
字段id属性为自动编码

xac=\"DELETE wenzhang WHERE id=\" & request.querystring(\"id\")
换成:

xac=\"DELETE * form wenzhang WHERE id=\" & request.querystring(\"id\")