I am trying to build a search page with multiple search parameters.... I have my recordset created using Dreamweaver 8. It works fine. The structure is the search form posts all the input field values into the result page. But the problem is, "ALL THE FORM(input)FIELDS MUST BE FILLED" to get the result. If I leave one parameter empty, the recordset returns with empty results as I have used "AND" with all the parameters.

I want to make each individual input fields optional with a check box... Can anybody suggest some solutions for that.....

Thanks in Advance.......

Edited by - satheeshkd on 24 Apr 2007 14:15:19

Edited by - satheeshkd on 24 Apr 2007 14:15:50

you might have to use php to examine the checkboxes and then build a query - I had something similar and wrote a function that added additional AND clauses onto the end of the query

thanks for the advice.

Unfortunately, I have to use only asp. I'm using Access database & a DSN is setup on the server. Will it be possible to find some solutions using asp?