主题:怎样对数据库的查询结果取整?
这是我的代码:
<html>
<body>
<%
set cn1=Server.Createobject("ADODB.Connection")
cn1.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.Mappath("db1.mdb")
sql = "select max(Entrancescore) as da from student "
Set rs=cn1.Execute(sql)
sq2="select min(Entrancescore) as xiao from student"
set rs2=cn1.execute(sq2)
sq3="select avg(Entrancescore) as pin from student"
set rs3=cn1.execute(sq3)
%>
最高分:<% = rs("da") %>
最低分:<% =rs2("xiao") %>
平均分:<% =rs3("pin") %>
<%
cn1.close
set cn1=nothing
%>
</body>
</html>
========================
[img]http://www.mybsb.net/bbs/UploadFile/2007-1/2007191343320269.jpg[/img]
平均分的显示结果为601.25,要求对这个数值取整数,应该怎么加代码呢?是加vb script代码吗?我只知道用int,但不知道怎么加进去。请问有谁能指点一下?
<html>
<body>
<%
set cn1=Server.Createobject("ADODB.Connection")
cn1.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="& Server.Mappath("db1.mdb")
sql = "select max(Entrancescore) as da from student "
Set rs=cn1.Execute(sql)
sq2="select min(Entrancescore) as xiao from student"
set rs2=cn1.execute(sq2)
sq3="select avg(Entrancescore) as pin from student"
set rs3=cn1.execute(sq3)
%>
最高分:<% = rs("da") %>
最低分:<% =rs2("xiao") %>
平均分:<% =rs3("pin") %>
<%
cn1.close
set cn1=nothing
%>
</body>
</html>
========================
[img]http://www.mybsb.net/bbs/UploadFile/2007-1/2007191343320269.jpg[/img]
平均分的显示结果为601.25,要求对这个数值取整数,应该怎么加代码呢?是加vb script代码吗?我只知道用int,但不知道怎么加进去。请问有谁能指点一下?