📄 admindelupd.asp
字号:
<%@ Language=VBScript %>
<%
'wrong login ...?
if session("login") <> "yes" then
Response.Redirect ("adminlog.asp")
end if
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<link rel="stylesheet" href="stili.css" type="text/css">
<title>Set active poll - update</title>
<%
on error resume next
'get poll name to delete...
a = Request.Form("delete")
'create connection...
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("../fpdb/engglas.mdb")
'query to select active data...
sql = "SELECT * FROM title where title = '" & a & "'"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
'get poll id...
b = rs.Fields ("id")
'delete record...
rs.Delete
'close connection and recordset...
rs.Close
set rs = nothing
%>
<%
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("../fpdb/engglas.mdb")
'query to select active data...
sql = "SELECT * FROM vote where id = " & b
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
do while not rs.eof
rs.Delete
rs.movenext
loop
rs.Close
set rs = nothing
conn.Close
set conn = nothing
%>
</HEAD>
<BODY>
<table width="200" border="1" cellspacing="0" align="center" style="border-collapse: collapse" cellpadding="10" bordercolor="#000000">
<tr>
<td bgcolor="#ADD8E6" align="center"><span class="nortxtv10">
<font color="red"><b>主题被删除!</b>
</font><p></p>
谢谢.<p></p><a href="admintit.asp">返回</a></span></td>
</tr>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -