查人人中国名人网clothing和clothes:ASP查询高手请进!
来源：百度文库 编辑：查人人中国名人网 时间：2024/04/25 03:50:43
看看下面的 怎么输出?输出全部.
<%dim sqlstr,rs
Set Rs=Server.createobject("ADODB.RECORDSET")
sqlstr="select * from CallNoUserAllCDR where startdateTime>'2006-07-05' and groupNo<>'softphone' order by GroupNo compute sum(ThisTimeFee) by groupNo"
Rs.open Sqlstr,conn,1,3
%>
<%dim sqlstr,rs
Set Rs=Server.createobject("ADODB.RECORDSET")
sqlstr="select * from CallNoUserAllCDR where startdateTime>'2006-07-05' and groupNo<>'softphone' order by GroupNo compute sum(ThisTimeFee) by groupNo"
Rs.open Sqlstr,conn,1,3
%>
response.write()