468,510 Members | 1,836 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

How do collect all data in combo box?

Hi!

Pls help me.
My backend is MS-Access.
This is my coding........

<%pathdefiner = "../"%>
<!--#include file="../Connection/connector.asp" -->

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Vote for your favorite song</title>
</head>

<body>

<h2><u><font color="#0000FF" face="Monotype Corsiva" size="6">Vote for your favorite song</font></u></h2>

<p>&nbsp;</p>
<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveResults"
U-File="C:\Inetpub\wwwroot\AspDemo\home\_private\for m_results.txt"
S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
<p>&nbsp;&nbsp;<font size="4">Songs</font>&nbsp;&nbsp;&nbsp;
<%
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = my_Conn

retrieveSql = "Select top 10 tbl_Vote_info.Item_code, tbl_Item_Master.Title from tbl_Vote_info, tbl_Item_Master where tbl_Vote_info.Item_code = tbl_Item_Master.Item_code order by Number_votes desc;"

rs.Source = retrieveSql
rs.Open
%>

<select size="1" name="D1">
<%
dim i
for i=1 to 10
Do While not rs.EOF

if(Strcomp(yCount,i)<>0) then %>
<option value="<%=i%>" selected><%=i%></option>
<%else%>
<option value="<%=i%>" ><%=i%></option>
<%End if%>

</select>
<%
rs.MoveNext

Loop
Next
rs.Close
my_Conn.Close
set rs=nothing
set my_Conn=nothing
%>
&nbsp;&nbsp;</p>
<p align="center"><input type="submit" value="Vote" name="B1"></p>
</form>

</body>

</html>
Mar 3 '10 #1
1 1645
jhardman
3,405 Expert 2GB
PLEASE post code in code tags. Please explain what you want to do and what you need help doing. Your post as is is very vague.

Jared
Mar 11 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by meganrobertson22 | last post: by
9 posts views Thread by Frank Rizzo | last post: by
5 posts views Thread by Mrinal Kamboj | last post: by
3 posts views Thread by rlm | last post: by
reply views Thread by Gian Paolo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.