asp 怎样和sql的compute by语句结合使用

[oceanmeng]

比如
<% SQLQuery4 = "select TeacherID,scienceresearchid,paytime,caculatesum "&_
"from scienceresearchcaculatesumtable "&_
"where TeacherID='004192' order by TeacherID "&_
"compute sum(caculatesum) by TeacherID"
Set RS4 = cn.Execute(SQLQuery4)
%>
<%do while not RS4.eof%>
<%'=trim(rs4("TeacherID"))%>——<%=trim(rs4("caculatesum"))%><br>
<%rs4.movenext
loop%>
在sql server2000中能够使用，与一般的查询显示的结果不同，我怎样用asp语句
把在sql server2000中显示的结果表类似的显示在网页中，谢谢

[funboy88]

用COMPUTE得到的是多条记录集，不是一条记录集，所以你需要用NextRecordset方法,不有只用一个RS的，需要用LOOP去取得下一个记录集


NextRecordset Method


Gets the next set of records, if any, returned by a multi-part select query in an OpenRecordset call, and returns a Boolean value indicating whether one or more additional records are pending (ODBCDirect workspaces only).

Syntax

boolean = recordset.NextRecordset

The NextRecordset method syntax has these parts:

Part Description
boolean A Boolean variable. True indicates the next set of records is available in recordset; False indicates that no more records are pending and recordset is now empty.
recordset An existing Recordset variable to which you want to return pending records.



demo:

booNext = True
intCount = 1
With rstTemp
Do While booNext
Debug.Print "Contents of recordset #" & intCount
Do While Not .EOF
Debug.Print , .Fields(0), .Fields(1)
.MoveNext
Loop
booNext = .NextRecordset //你的用法主要是这个的，用一个循环
Debug.Print " rstTemp.NextRecordset = " & _
booNext
intCount = intCount + 1
Loop
End With