中央空调多联机安装:Microsoft JET Database Engine (0x80040E14) 语法错误 (操作符丢失)
来源:百度文库 编辑:高考问答 时间:2024/05/11 16:49:02
<% Dim DB
DB="example.mdb"
set conn=server.CreateObject("adodb.connection")
conn.open "provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath(DB)
exec="select * from Guestbook where id="&request.querystring("id")
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,1,1
%>
<form name="form1" method="post" action="modify.asp">
<table width="200" border="1">
<tr>
<td>姓名</td>
<td>电话</td>
</tr>
<% do while not rs.eof%><tr>
<td><input name="name" type="text" value="<% =rs("name")%>"></td>
<td><input name="tel" type="text" value="<% =rs("tel")%>"></td>
</tr>
<tr>
<td>
<div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td><input name="hidden" type="text" id="hidden" value="<% =request.querystring("id")%>"></td>
</tr>
<% rs.movenext
loop
%>
</table>
</form>
<% rs.close
set rs=nothing
conn.close
set conn=nothing
%>
提示:
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'id=' 中。
那位帮我看看怎么回事 谢谢!
DB="example.mdb"
set conn=server.CreateObject("adodb.connection")
conn.open "provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath(DB)
exec="select * from Guestbook where id="&request.querystring("id")
set rs=server.CreateObject("adodb.recordset")
rs.open exec,conn,1,1
%>
<form name="form1" method="post" action="modify.asp">
<table width="200" border="1">
<tr>
<td>姓名</td>
<td>电话</td>
</tr>
<% do while not rs.eof%><tr>
<td><input name="name" type="text" value="<% =rs("name")%>"></td>
<td><input name="tel" type="text" value="<% =rs("tel")%>"></td>
</tr>
<tr>
<td>
<div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td><input name="hidden" type="text" id="hidden" value="<% =request.querystring("id")%>"></td>
</tr>
<% rs.movenext
loop
%>
</table>
</form>
<% rs.close
set rs=nothing
conn.close
set conn=nothing
%>
提示:
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'id=' 中。
那位帮我看看怎么回事 谢谢!
Microsoft JET Database Engine是什么?
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80004005)
Microsoft Jet 数据库引擎打不开文件 怎么办?
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E4D)