<%
numyue=month(date())
numri=day(date())
sql="SELECT * FROM sq1 WHERE (MONTH(stardate) ="&numyue&") AND (YEAR(stardate) ="&numri&") "
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
do while not rs.eof
%><%response.Write rs("llsq")%> <%rs.movenext
loop
rs.close%>
我改成了这样,还是慢死
numyue=month(date())
numri=day(date())
sql="SELECT * FROM sq1 WHERE (MONTH(stardate) ="&numyue&") AND (YEAR(stardate) ="&numri&") "
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
do while not rs.eof
%><%response.Write rs("llsq")%> <%rs.movenext
loop
rs.close%>
我改成了这样,还是慢死