How can enter value on dropdown list.
I am retrive record from the database.dropdown list is very long,
How can enter value in drowdown option to retrieve the records.
Select option should be display and enter value and retrieve the records.

what amemdment will made the following coding.

<form method=post action=tripimages\contno.asp id=contractno name=contractno>
  <TR>
    <TD>Contract No :</TD>
    <TD><SELECT id=contractno name=contractno> <OPTION selected>
<%
dim ssql
set cn=server.CreateObject("adodb.connection")
cn.ConnectionString="Provider=SQLOLEDB.1;Integrate d Security=SSPI;Persist Security Info=False;Initial Catalog=dcil;Data Source=AUHTRIPSVR2"
cn.Open

ssql="select distinct contractno from arc order by contractno"

set rs=cn.Execute(ssql)
do while rs.eof=false
Response.Write("<option value='" & rs("contractno") & "'>")
Response.Write(rs("contractno") )
rs.movenext
loop
%>

  </OPTION></SELECT><INPUT style="WIDTH: 48px; HEIGHT: 24px" type=submit size=16 value=search id=submit1 name=submit1></TD></TR>
  </form>

regards.

Mateen Martin
[email protected]

One big problem i see is that you aren't closing your OPTION tags inside the loop. The last part of your code should read:

set rs=cn.Execute(ssql)
do while rs.eof=false
Response.Write("<option value='" & rs("contractno") & "'>")
Response.Write(rs("contractno") )
Response.Write("</option>")
rs.movenext
loop
%>

  </SELECT><INPUT style="WIDTH: 48px; HEIGHT: 24px" type=submit size=16 value=search id=submit1 name=submit1></TD></TR>
  </form>