Hi all,
Here's my situation. I set up a database for a local employment service to search their job listings. There are four search fields. Position, State/Location, Salary, and Key words. All work as designed except the State search. The form element is a list menu with multiple selections checked. The State search works only when one item is selected. The search criteria is displayed on the results page and all selected states are delimited with ", " (e.g. Arizona, California, etc.). I need to search each selection in the same database field from the list menu. Does anybody have any ideas for a solution. All responses would be deeply appreciated.
URL:
Programming Language:
ASP, Java Script.
SQL:
Where Location LIKE '%job_region%' AND Salary LIKE '%job_salary%' AND Title
LIKE '%job_position%' AND KeyWords LIKE '%job_words%'
Variables:
Session.Form("region"
Session.Form("salary"
Session.Form("position"
Session.Form("words"
I use MS Personal Web Server on my local machine and run the database on a
MYSQL server. I do this all the time and have not had any problems until
now. It does not work on either machine.
Thanks In Advanced,
Doug
Here's my situation. I set up a database for a local employment service to search their job listings. There are four search fields. Position, State/Location, Salary, and Key words. All work as designed except the State search. The form element is a list menu with multiple selections checked. The State search works only when one item is selected. The search criteria is displayed on the results page and all selected states are delimited with ", " (e.g. Arizona, California, etc.). I need to search each selection in the same database field from the list menu. Does anybody have any ideas for a solution. All responses would be deeply appreciated.
URL:
Programming Language:
ASP, Java Script.
SQL:
Where Location LIKE '%job_region%' AND Salary LIKE '%job_salary%' AND Title
LIKE '%job_position%' AND KeyWords LIKE '%job_words%'
Variables:
Session.Form("region"
Session.Form("salary"
Session.Form("position"
Session.Form("words"
I use MS Personal Web Server on my local machine and run the database on a
MYSQL server. I do this all the time and have not had any problems until
now. It does not work on either machine.
Thanks In Advanced,
Doug