<%@ Language=VBScript %>
<%
'wrong login ...?
if session("login") <> "yes" then
Response.Redirect ("adminlog.asp")
end if
%>
Set active poll - update
<%
'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
rs.Delete
rs.Close
set rs = nothing
conn.Close
set conn = nothing
%>