Drop down menus

I have a search page which allows the user to search through arrays sent with the page using drop down menus. Javascript is used for this part. The user sarches by Flow Cv, orifice Size and Port Connection. <br><br>I have an MS Access database which has fields Flow_cv, Orifice_size and port_connection, Speciication, price etc. <br><br>On my search page I have a form to use the drop-down menus then submit <br><br><br>I have been trying to get the sql working on the asp page which the form submits to but cant seem to get it working. I have been trying the following but with no success. <br><br>SQL_query = "SELECT * FROM products WHERE Flow_Cv = '" & Request.Form("firstChoice") & "' AND Orifice_size = '" & Request.Form("secondChoice") & "' AND Port_Connection = '" & Request.Form("thirdChoice") & "'"<br><br>i want it to take the information the user has selected from the drop-down menus. i.e Flow Cv, orifice size and port connection. I want the query search the DB and find the products which match the selections and return all the details held on it. <br><br>I have the page loading but the sql doesnt seem to be querying the DB.<br><br>Any advice would be appreciated, <br><br>Regards <br>Andy

First, if you have not already, insert Response.Write(SQL_query) on your page to display sql statement on page. <br><br>Next you might need to take a look at how you are handeling nulls. (unless all of your fiels have values) Do you have default values for your form fields? If you are searching for a null value, it will try to match those values.<p> </p><p><hr size="1" width="50%" align="left" />James Wood<br>jgwood@dot.state.az.us</p>