how to create dynamic where clause

[dharkangel]

hello,

I created an asp page that will allow users to click on any number of checkbox options and click submit. When they get to the action page, these checkboxes they chose should generate a report based on their selections. The problem is, I can't predict the combination or the amount of options they may choose. How is the best way to compensate for this in regards to my where clause?

below is my sql statement as it works now with only one option chosen:

componentName = Request.QueryString("component")

mySQL = "SELECT * FROM getBarcelonaBestPerformersByComponent"

'WHERE STATEMENT
If componentName <> "All" then
mySQL = mySQL & " WHERE Component = '" & componentName & "';"
end If

 

[Remou]

How about IN:
Where ComponentName IN ("a","b","c")