|
crosscreek -> search sql with multiple criteria (4/16/2008 21:53:13)
|
Working on a search form with multiple entries. I think I can create the asp code for this, but working on the SQL for the criteria inputted. (YES THE DOG DATABASE)
Example.
Search Form:
Color:
color factor:
location:
price range:
Results.asp
col = request.form("color")
factor = request.form("factor")
location = request.form("location")
price = request.form ("Price")
select * from tbldog where color = col AND factor = factor AND location = location And price = price.
I know how to make the SQL to match all the criteria inputted, but how do I handle if someone what's to find matches to part of the criteria.
Do I need to break up the code into several parts.
For example if someone wants to see all the dog that are located in Texas.
col = all
price = all
location = TX
factor = all
OR texas dog's that are chocolate factored
col = all
price = all
location = TX
factor = choc
|
|
|
|
