I'd like to pass the value from a select box to a query, and have the query return a less than or equal to the selection
(HTML)
<select name="intPrice">
            <option value="all">All Price Levels
            <option value="100">Under $100</option>
            <option value="1000">Under $1000</option>
            <option value="10000">Under $10,000</option>
            <option value="100000">Under $100,000</option>
        </select>


(Where Clause on results page)
sqlText = sqlText & "where products.productPrice <= " & intPrice & " products.catalogID = " & strCat & ""

I think I'm close but any help is appreciated.

Just because you can, it doesn't mean you should

Hi,


sqlText = sqlText & "where products.productPrice <= " & intPrice & " products.catalogID = " & strCat & ""


Here, u r referring select control name directly(intPrice). It wont get any value like this. You must submit the form to the server and refer this control as request.form("intPrice")
This will return the value property of select control in which the item is selected.


-----------
Rajani

Hi,
yes to rajini ..
as he said u can't use the name direct...
submit to the server...
and from there use request.from to accomplish your task...
bye for now...


MuthuKumar.AL