📄 poll.asp
字号:
<%
'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, vote where title.active = 'y' and title.id = vote.id"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="stili.css" type="text/css">
<title>Poll</title>
</head>
<body>
<div align="center">
<center>
<table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#000000" width="250">
<tr>
<td width="100%" align="center" bgcolor="#ADD8E6">
<span class="nortxtv10">
<b><font color="#00008B">
<%
'if no data in database for selected query...
if rs.eof then
%>
<br />
当前主题:<br />
<br />
<table width="200" border="1" cellspacing="0" style="border-collapse: collapse"
cellpadding="3" bordercolor="#000000">
<tr>
<td bgcolor="#336699" align="center"><span class="nortxtv10">
<font color="#FFFFFF">
<b>没有当前主题!</b></font></span></td>
</tr>
</table>
<%else%>
<form action="updateeng.asp?title=<%=rs.fields("title")%>" method="POST" id="form1" name="form1">
<br />
当前主题:<br />
<br />
<table width="200" border="1" cellspacing="0" style="border-collapse: collapse" cellpadding="3" bordercolor="#000000">
<tr>
<td bgcolor="#336699" align="center"><span class="nortxtv10">
<font color="#FFFFFF"><b><%=rs.fields("title")%></b></font></span> </td>
</tr>
<tr>
<td align="left" valign="middle" bgcolor="#FFFFFF">
<%
'create radio buttons
for a = 1 to rs.recordcount
%>
<input type="radio" name="polli" value="<%=rs.fields("answer")%>"><span class="nortxtv10"><%=rs.fields("answer")%></span><br />
<%
rs.movenext
if rs.eof then
rs.movelast
end if
next
%>
</td>
</tr>
<tr>
<td bgcolor="#336699" align="center">
<input type="image" name="sql" src="images/gl.gif" align="absmiddle" width="50" height="17">
<a href="vote.asp?sql=<%=rs.fields("title")%>"><img border="0" src="images/pra.gif" align="absmiddle" WIDTH="50" HEIGHT="17"></a></td>
</tr>
</table>
</font></b>
<br>
</form>
<%end if%>
<%
'close recordset
rs.Close
set rs = nothing
'open rs with new query .. to select inactive data...
sql = "SELECT * FROM title where active = 'n'"
set rs = server.CreateObject ("ADODB.Recordset")
rs.Open sql, conn, 3, 3
%>
<form action="vote.asp" method="POST">
其他投票主题<br>
<br/>
<select size="1" name="sql">
<%
'fill drop-down list...
for g = 1 to rs.recordcount
%>
<option value="<%=rs.fields("title")%>"><%=rs("title")%></option>
<%
rs.MoveNext
if rs.eof then
rs.movelast
end if
next
%>
</select><br>
<br>
<input type="image" src="images/pr.gif" name="sql" align="absmiddle" width="50" height="17"></p>
</form>
</span>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
<% 'close connection and recordset...
rs.Close
set rs = nothing
conn.Close
set conn = nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -