在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

但是只显示一条内容 ,不能用循环语句全部出来

你加个循环啊

循环后出现这个

t1              t2                 t3
2006-8-18       2048              15
2006-8-18       2048              15
2006-8-18       2048              15
2006-8-18       2048              15
2006-8-18       2048              15
2006-8-18       2048              15
2006-8-18       2048              15