您所在位置：主题：请教:怎么显示数据库中的记录？我的这个程序错在哪里..
maoqiu
[专家分：0] 发布于 2007-01-09 01:18:00
显示出student表中入学最高分，最低分与平均分。数据库名为db1.mdb 表名为student。
======================================
以下是我的代码:
<%@ language=vbscript %>
<%
dim cn1,sq1,sq2,sq3,zx1,zx2,zx3
set cn1=Server.CreateObject("ADODB.Connection")
cn1.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.Mappath("db1.mdb")
sq1="select max(Entrancescore) from student"
sq2="select min(Entrancescore) from student"
sq3="select avg(Entrancescore) from student"
zx1=cn1.execute(sq1)
zx2=cn1.execute(sq2)
zx3=cn1.execute(sq3)
%>
<html><body>
<table width="18%" border="2" align="center">
<tr>
<td><div align="center">最高分</div></td>
<td><div align="center">最低分</div></td>
<td><div align="center">平均分</div></td>
</tr>
<%
Response.Write "<TR>"
Response.Write " <TD align=Center>'&zx1&'</TD>"
Response.Write " <TD align=Center>'&zx2&'</TD>"
Response.Write " <TD align=Center>'&zx3&'</TD>"
Response.Write "</TR>"
%>
<%
cn1.close
set cn1=nothing
%>
</table>
</body></html>
=============================
结果显示出来的东西就不对了,表格里显示出的却是&zx1&,&zx2&,&zx3&这种东西.请问应该怎么在单元格里显示查询的结果呢?不配置ADODB,也不用Recordset.
======================================
以下是我的代码:
<%@ language=vbscript %>
<%
dim cn1,sq1,sq2,sq3,zx1,zx2,zx3
set cn1=Server.CreateObject("ADODB.Connection")
cn1.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.Mappath("db1.mdb")
sq1="select max(Entrancescore) from student"
sq2="select min(Entrancescore) from student"
sq3="select avg(Entrancescore) from student"
zx1=cn1.execute(sq1)
zx2=cn1.execute(sq2)
zx3=cn1.execute(sq3)
%>
<html><body>
<table width="18%" border="2" align="center">
<tr>
<td><div align="center">最高分</div></td>
<td><div align="center">最低分</div></td>
<td><div align="center">平均分</div></td>
</tr>
<%
Response.Write "<TR>"
Response.Write " <TD align=Center>'&zx1&'</TD>"
Response.Write " <TD align=Center>'&zx2&'</TD>"
Response.Write " <TD align=Center>'&zx3&'</TD>"
Response.Write "</TR>"
%>
<%
cn1.close
set cn1=nothing
%>
</table>
</body></html>
=============================
结果显示出来的东西就不对了,表格里显示出的却是&zx1&,&zx2&,&zx3&这种东西.请问应该怎么在单元格里显示查询的结果呢?不配置ADODB,也不用Recordset.
