<%
set rs= server.CreateObject("adodb.recordset")
rs.open "select top 1 * from china where have = 0 order by newid()" ,conn,1,1
if not rs.eof then
id=rs("id")
end if
rs.close
set rs=nothing
sql = "update china set have = 2 , ip2 = 100 where id=" & id
conn.execute sql
%>
错误为:
An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.
如果去掉top 1 和 order by newid() 就正常了 请问怎么处理? 能正常显示!!
set rs= server.CreateObject("adodb.recordset")
rs.open "select top 1 * from china where have = 0 order by newid()" ,conn,1,1
if not rs.eof then
id=rs("id")
end if
rs.close
set rs=nothing
sql = "update china set have = 2 , ip2 = 100 where id=" & id
conn.execute sql
%>
错误为:
An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here to find out more about this error.
如果去掉top 1 和 order by newid() 就正常了 请问怎么处理? 能正常显示!!