Searching multiple fields from a multi-selection dropdown list
I want to build a query that looks like this:
WHERE (subCatID = 7 OR subCatID2 = 7 OR subCatID = 11 or subCatID2 = 11) AND etc.
The numbers 7 or 11 come from a dropdown list. subCatID and subCatID2 are two fields of the database.
So I want to be able to search two fields with multiple selections from a dropdown list.
I cannot set this up using the DataAssist Interface. Can you tell me how to modify this manually?
The following code does not quite get me there:
'keyword array declarations
'comparison list additions
WAQueryBuilder1_whereClause=BuildFromList("subCatID","subcatID","","=",1,WAQueryBuilder1_wildCard,WAQueryBuilder1_dateSeparator,WAQueryBuilder1_whereClause)
WAQueryBuilder1_whereClause=BuildFromList("subCatID2","subcatID","OR","=",1,WAQueryBuilder1_wildCard,WAQueryBuilder1_dateSeparator,WAQueryBuilder1_whereClause)
WAQueryBuilder1_whereClause=BuildFilterString("dwft","" & cStr( Request.QueryString("minwft") ) & "","AND",">=",1,WAQueryBuilder1_wildCard,WAQueryBuilder1_dateSeparator,WAQueryBuilder1_whereClause)
etc.
It gives me... WHERE ((subCatID = 10) OR (subCatID = 43)) OR ((subCatID2 = 10) OR (subCatID2 = 43)) AND (dwft >= 8) AND etc.
The parentheses are not in the right groupings.