Using Dreamweaver MX and ASP, I am trying to create form and results page in which the user can select multiple checkbox options, which are displayed accordingly on the resulting page. Don't know whether my SQL query is right, but here it is:
SELECT *
FROM Tools
WHERE Manufacturer LIKE '%var_manuBosch%' AND Manufacturer LIKE '%var_manuDeWalt%' AND Tool LIKE '%var_toolGrinder%' AND Tool LIKE '%var_toolScrewdriver%' AND Tool LIKE '%var_toolRecSaw%' AND Tool LIKE '%var_toolCircSaw%'

My default value for every variable is %

If I select more than one checkbox, this query returns no results.

Any advice? Thanks.

Use OR instead of AND