Multiple values for a single drop list choice

[Mark]

Is it possible for a single choice in a drop list to pass
multiple or a range of values to an ASP? I'd like to
query my database to see if a single value there falls
within a range of values from the drop list. (This is
all numeric.) Can I do something like >0<10 and thereby
pass 1 through 9?

-Mark

 

[Mark]

Never mind. I took a different tact and passed two
variables to the ASP and compare the two. I think it's
probably easier to do it this way.

Thanks anyway.

Mark

 

[Jon Spivey]

Hi,
you could do
<option value ="between 1 and 9"> 1 to 9</option>
then build up your sql
sql="select * from table where fieldname " & request("selectbox")