|
| |
|
|
crosscreek
Posts: 107
Joined: 2/5/2008
Status: offline
 |
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
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
