<!--#include file="data.asp"-->
<%id=request("txtid")
set rs=conn.execute("select *from ziliao where ID='" &id&"'")"
do while not rs.eof
if rs("开通")="false" then
id=rs("id")
Response.Redirect "sedit.asp?id="&id
end if
rs.movenext
loop
rs.close
set rs=nothing %>
sedit.asp
<%
id=request.querystring("id")
sql_update="update ziliao set flag='true' where id="&id
cn.execute sql_update
showmsg "确认已开通!","刚才的页面.asp"
%>
<!--#include file="data.asp"-->
<%id=request("txtid")
set rs=conn.execute("select *from ziliao where ID='" &id&"'")
if rs.bof or rs.eof then
rs("开通")=true
rs("开通日期")=now
rs.update
rs.close
set rs=nothing
end if%>
我这样写可以吗`!
可以修改一下吗`