How to refer a item in combo box in ASP?

[longmatch]

I would like to run a query based upon selection in a combo box in my ASP page. How can I refer the item user has selected?

Thanks

Haijun

 

[denoxis]

Let's say combo box items are like this:

<select name=myCombo>
<option value=1>First
<option value=2>Second
</select>

When you submit this in a form, you can request it by its name and use it whereever you want which is something like
<%
selectedOption = request.form(&quot;myCombo&quot
SQL = &quot;SELECT * FROM tbl WHERE ID = &quot; & selectedOption
' selectedOption is either &quot;1&quot; or &quot;2&quot; in this example
%>

 

[longmatch]

My problem was solved under your help.

Thanks


Haijun