How can I make a searchable drop down down box in ASp language ?

Question

II have a database that have a field call Item number.
this table is getting too big and two long , the drop down box goes down the page 4 fold .
so I need a a searchable drop down that user can enter the first two or 3 word of the itam number and cursor would jump to closes item number possible.

Please answer for ASP and NOT for ASP.net
no no on asp.net

I downloaded the demo , this is too hard to read off of.

need something that I can get with dreamweaver editor or FrontPage.

Answer 1

The answer you need is actually going to be in neither ASP or ASP.NET.

What you need is some sort of client side processing using a script language.

Use ASP to put the list into an array.
You now need to have an onChange function on the text box that the user will enter the first few characters.

Your onChange function will first clear the dropdown list. Then it will select the items that meet the requirements from the array and put them into the dropdown list.

Answer 2

I use a searchable drop down add on for ASP but it uses Ajax (Active X, Java Script). The Nitobi Combo Box will do exactly what you are talking about. As you type, it filters out the data that does not match your criteria. It is a very cost effective solution.

http://www.nitobi.com/products/

Enjoy!