4,011
社区成员
发帖
与我相关
我的任务
分享
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 10 dk_news_name_unit,count(*) as my_need_num_k from dk_news_unit group by dk_news_name_unit order count(*) desc "
rs.Open sql, conn, 1, 1
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 10 dk_news_name_unit,count(*) as my_need_num_k from dk_news_unit group by dk_news_name_unit order my_need_num_k desc "
rs.Open sql, conn, 1, 1
for i=1 to 10
response.Write "<script language=javascript>alert('"&rs("dk_news_name_unit")&rs("my_need_num")&"');</script>"
rs.movenext
next
exit for
for i=1 to 10 response.Write "<script language=javascript>alert('"&rs("dk_news_name_unit")&rs("my_need_num")&"');</script>" rs.movenext next
请教如何中途退出 例如break;
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 10 dk_news_name_unit,count(*) as my_need_num_k from dk_news_unit group by dk_news_name_unit order count(*) desc "
rs.Open sql, conn, 1, 1
Set rs = server.CreateObject("adodb.recordset")
sql = "select top 10 dk_news_name_unit,count(*) as my_need_num_k from dk_news_unit group by dk_news_name_unit order my_need_num_k desc "
rs.Open sql, conn, 1, 1
for i=1 to 10
response.Write "<script language=javascript>alert('"&rs("dk_news_name_unit")&rs("my_need_num")&"');</script>"
rs.movenext
next