如何显示汇总的多条记录?
在ASP网页中
dim t1,t2,t3
set rs=server.createobject("adodb.recordset")
sqltext="select w_date as t1,sum(w_sale) as t2 ,sum(w_shulian) as t3 from weiya01 group by w_date"
rs.open sqltext,conn,1,1
t1=rs("t1")
t2=rs("t2")
t3=rs("t3")
用这句能查出内容,
t1 t2 t3
2006-8-18 2048 15
但是只显示一条内容 ,不能用循环语句全部出来