<TR> <TD language=javascript onmouseup="opencat(cat10<%=i%>000, img10<%=i%>000);" id=item$pval[catID]) style="CURSOR: hand" width=34 height=24 align=center><IMG id=img10<%=i%>000 src="img/class1.gif" width=20 height=20></TD> <TD width="662"><a href='Product.asp?BigClassName=<%=rsbig("BigClassName")%>'><%=rsbig("BigClassName")%></a></TD> </TR> <TR> <TD id=cat10<%=i%>000 <%if rsbig("BigClassName")=BigClassName then response.write "style='DISPLAY'" else response.write "style='DISPLAY: none'" end if%> colspan="2"> <% dim rsSmall,sqls,j set rsSmall = server.CreateObject ("adodb.recordset") sqls="select * from SmallClass where BigClassName='" & rsbig("BigClassName") & "' order by SmallClassID" rsSmall.open sqls,conn,1,1 if rsSmall.eof and rsSmall.bof then Response.Write "没有小类" else j=1 do while not rsSmall.eof %> <IMG height=20 src="img/class3.gif" width=26 align=absMiddle border=0><a href="Product.asp?BigClassName=<%=rsSmall("BigClassName")%>&Smallclassname=<%=rsSmall("SmallClassName")%>"><%=rsSmall("SmallClassName")%></a><BR> <% rsSmall.movenext j=j+1 loop end if rsSmall.close set rsSmall=nothing %> </TD> </TR> <% rsbig.movenext i=i+1 loop rsbig.close set rsbig=nothing end if %> </TABLE> <% end Sub
'================================================= '过程名:ShowVote '作 用:显示网站调查 '参 数:无 '================================================= sub ShowVote() dim sqlVote,rsVote,i sqlVote="select top 1 * from Vote where IsSelected=True" Set rsVote= Server.CreateObject("ADODB.Recordset") rsVote.open sqlVote,conn,1,1 if rsVote.bof and rsVote.eof then response.Write " 没有任何调查" else response.write "<form name='VoteForm' method='post' action='vote.asp' target='_blank'><td>" response.write rsVote("Title") & "<br><br>" if rsVote("VoteType")="Single" then for i=1 to 8 if trim(rsVote("Select" & i) & "")="" then exit for response.Write "<input type='radio' name='VoteOption' value='" & i & "'>" & rsVote("Select" & i) & "<br>" next else for i=1 to 8 if trim(rsVote("Select" & i) & "")="" then exit for response.Write "<input type='checkbox' name='VoteOption' value='" & i & "'>" & rsVote("Select" & i) & "<br>" next end if response.write "<br><input name='VoteType' type='hidden'value='" & rsVote("VoteType") & "'>" response.write "<input name='Action' type='hidden' value='Vote'>" response.write "<input name='ID' type='hidden' value='" & rsVote("ID") & "'>" response.write "<a href='javascript:VoteForm.submit();'><img src='images/voteSubmit.gif' width='52' height='18' border='0'></a> " response.write "<a href='Vote.asp?Action=Show' target='_blank'><img src='images/voteView.gif' width='52' height='18' border='0'></a>" response.write "</td></form>" end if rsVote.close set rsVote=nothing end sub