这个错误是什么意思呀??高手帮忙.要数年据库的留言!!
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14' [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '* form stu where id = (, )' 中。
/students.ASP，行 55
<%response.expires=0%>
<%
set conn=server.createobject("adodb.connection")
DSNtemp = "Driver={Microsoft Access Driver (*.mdb)};"
DSNtemp = DSNtemp & "DBQ=" & server.mappath("date/student.mdb")
conn.open DSNtemp
stext = "select id,xuehao,xingming,zhiwu, banji,chushengnianyue,minzu,zhengzhimianmao,dangtuanshijian,jiguan,ruwushijian,wenhuachengdu,lianxidianhua,ruwudiqu,jiatingzhuzhi,youzhengbianma from stu order by banji desc"
set rs = conn.execute(stext)
if rs.eof then
response.write "database error"
response.end
end if
%>
<html>
<head>
<%
'set conn=server.createobject("adodb.connection")
'conn.open("DRIVER=Driver do Microsoft ACCESS (*.mdb);dbq="&server.mappath("student.mdb"))
set rs=server.createobject("adodb.recordset")
sql="select * from stu"
rs.open sql,conn,3
rs.pagesize=20
if request("page")<>"" then
epage=cint(request("page"))
if epage<1 then epage=1
if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
rs.absolutepage=epage
%>
<title>fds</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
a:link { color: #000000; text-decoration: none}
a:visited { color: #000000; text-decoration: none}
-->
</style>
<style type="text/css">body {margin:0;}</style>
<script language="javascript">
function CheckAll(){
for (var i=0;i<form2.elements.length;i++){
var e =form2.elements[i];
if (e.name != 'chkall') e.checked =form2.chkall.checked;
}
}
</script>
</head>
<%
if request.form("action")="删除" then
Ann=request.form("Ann")
if Ann<>"" and not isnull(Ann) then
conn.execute "delete * form stu where id = ("&Ann&")"
end if
end if
%>
<body bgcolor="#FFFFFF" text="#000000">
<h2 align="center">欢迎来到fdsaf管理系统</h2>
<h4 align="center">可以点击某一行姓名来察看详细信息</h4>
<p><font color="#0066CC">相关操作: <a href="/xy_add.asp">添加学员</a> | <a href="/students.asp">显示信息</a>
| <a href="/index.ASP">退出登陆</a></font></p>
<p>
<form name="form1" method="post" action="/ss.asp">
<td> 姓名
<input name="xingming" type="text" maxlength="10" size="15">
班级
<input name="banji" type="text" maxlength="10" size="15">
<input name="submit" type="submit" value="显示学生">
</td>
</form>
</p>
<hr size=3 noshadow width=150% align=left></hr>
<div align="center"> <form name="form2" method="post" action="">
<table width="1600" border="1" cellpadding="0" cellspacing="0" bgcolor="#C7E8F8">
<tr>
<td height="22"><div align="center">
</div></td>
<td>
<div align="center"><font color="#FF0000">姓名</font></div>
</td>
<td>
<div align="center">学号</div>
</td>
<td>
<div align="center">职务</div>
</td>
<td>
<div align="center">班级</div>
</td>
<td>
<div align="center">出生年月</div>
</td>
<td>
<div align="center">民族</div>
</td>
<td>
<div align="center">政治面貌</div>
</td>
<td>
<div align="center">党团时间</div>
</td>
<td>
<div align="center">籍贯</div>
</td>
<td>
<div align="center">入学时间</div>
</td>
<td>
<div align="center">文化程度</div>
</td>
<td>
<div align="center">联系电话</div>
</td>
<td>
<div align="center">入学地区</div>
</td>
<td>
<div align="center">家庭地址</div>
</td>
<td>
<div align="center">邮政编码</div>
</td>
</tr>
<%
Do while not rs.eof
%>
<TR>
<td height="22"><div align="center">
<input type="checkbox" name="Ann" value="<%=cstr(id)%>" style="width:16px; height:16px;" />
</div></td>
<TD><div align="center"><a href='/stu_xx.asp?id=<%=rs("id") %>'><%=rs("xingming") %></a></div></TD>
<%
%>
<td><div align="center">0<%=rs("xuehao") %></div></td><td><div align="center"><%=rs("zhiwu") %></div></td><td><div align="center"><%=rs("banji") %></div></td><td><div align="center"><%=rs("chushengnianyue") %></div></td><td><div align="center"><%=rs("minzu") %></div></td><td><div align="center"><%=rs("zhengzhimianmao") %></div></td><td><div align="center"><%=rs("dangtuanshijian") %></div></td><td><div align="center"><%=rs("jiguan") %></div></td><td><div align="center"><%=rs("ruwushijian") %></div></td><td><div align="center"><%=rs("wenhuachengdu") %></div></td><td><div align="center"><%=rs("lianxidianhua") %></div></td><td><div align="center"><%=rs("ruwudiqu") %></div></td><td><div align="center"><%=rs("jiatingzhuzhi") %></div></td><td><div align="center"><%=rs("youzhengbianma") %></div></td></tr>
<%
rs.movenext
Loop
%>
</table>
<p align="center">
</p>
<p align="center">现在是第<%=epage%>页一共有<%=rs.pagecount%>页
<a href="/students.ASP">首页</a>
<a href="/students.ASP?page=<%=epage-1%>">前一页</a>
<a href="/students.ASP?page=<%=epage+1%>">后一页</a>
<a href="/students.ASP?page=<%=rs.pagecount%>">末页</a></p>
<span class="STYLE13"> 全选/不选</span>
<input type="checkbox" name="chkall" onclick="CheckAll();" style="width:16px; height:16px;" />
<td colspan="2" align="right"><input type="submit" name="action" value="删除" />
<input name="deleteorupdate" type="hidden" id="deleteorupdate">
<input name="deleteall" type="hidden" id="deleteall">
<input name="caozuo" type="hidden" id="caozuo">
</form>
</div>
<%
rs.close
conn.close
%>
</body>
</html>
