asp输出数据

发布网友 发布时间：2024-10-24 06:25

我来回答

共2个回答

热心网友 时间：2024-10-26 18:38

用Number1=70作为查询条件构造SQL语句,然后循环输出就行了,如
<%
Dim Rs, Sql
Rs = Server.CreateObject("ADODB.RecordSet")
Sql = "SELECT * FROM 表名 WHERE Number1=70"
Rs.Open Sql, Conn, 1, 1 '假设Conn是已打开的数据库连接对象
Do Until Rs.Eof
Response.Write Rs(1) & " / " & Rs(2) & " / " & Rs(3) & "<br>" '这里换成你想要的格式
Rs.MoveNext
Loop
Rs.Close
Set Rs = Nothing
%>

热心网友 时间：2024-10-26 18:33

you can try use SQL to select the number by group, then having count>1

Then use asp to display the data from database