Having problems selecting multiple values from a drop-down field to search my DB

I am having some difficulties with a customized Web search that I am doing. I have everything working to be able to select specific values from six drop-down fields to search my database. For example: field=Region and the user can select NA, LA, EU or AP. It works fine for just selecting NA, but I cannot get it to work when selecting multiple values like NA and LA.
You need to look at the formula you use for creating your query expression. I expect you're doing something like:

... + "([Region] = " + fldRegion + ")" + ...

If fldRegion is multi-valued, this results in a mess -- a multi-valued result, when you need a single-valued string as your query. You would have to instead write something like:

... + "([Region] = ("" + @Implode(fldRegion; "" or "") + "")" + ...

This was first published in June 2003

Back to top