response.write av
我自己用了，还是不行啊~

<%
sql="select sum(chengji) as sum,count(chengji) as count from student"
rs.open sql,conn,1,1
av=rs("sum")/rs("count")
response.write av %>
试一下

[此贴子已经被作者于2005-11-28 15:17:49编辑过]

dim conn,rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("sai.mdb")
'新版本连接数据库
Set rs = Server.CreateObject("ADODB.Recordset")
%>
这是我连数据库的文件，
<%
sql="select sum(chengji) as sum,count(chengji) as count from student"
rs.open sql,conn,1,1
av=sum/count
response.write av %>
也不行啊~~~
刚才那

[此贴子已经被作者于2005-11-28 15:22:01编辑过]

dim conn,rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("sai.mdb")
'新版本连接数据库
Set rs = Server.CreateObject("ADODB.Recordset")
%>
这是我连数据库的文件，

<%dim mycount,mysum,av
sql="select sum(chengji) as mysum,mycount(chengji) as mycount from student"
rs.open sql,conn,1,1
av=rs("mysum")/rs("mycount")
response.write av
%>

[此贴子已经被作者于2005-11-28 15:35:48编辑过]

还是不行啊`~~~~
http://www.jz173.net/dispbbs.aspx?board_id=20&id=208183
这有点提示，我还是搞不到。

dim conn,rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("sai.mdb")
'新版本连接数据库
Set rs = Server.CreateObject("ADODB.Recordset")
%>
这是我连数据库的文件，

<%dim mycount,mysum,av
sql="select sum(chengji) as mysum,mycount(chengji) as mycount from student"
rs.open sql,conn,1,1
av=rs("mysum")/rs("mycount")
response.write av              
%>
看一下是什么提示!!

[此贴子已经被作者于2005-11-28 15:45:44编辑过]

不行啊~~~

也是那样，缺少对象

dim conn,rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("sai.mdb")
'新版本连接数据库
Set rs = Server.CreateObject("ADODB.Recordset")
%>
这是我连数据库的文件，

<%dim mycount,mysum,av
sql="select sum(chengji) as mysum,count(chengji) as mycount from student"
rs.open sql,conn,1,1
av=rs("mysum")/rs("mycount")
response.write av
%>

什么提示,刚才写错了几个词,不好意思!!

还是不行啊~~~~