Q

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
This Content Component encountered an error

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchDataCenter

SearchExchange

SearchContentManagement

Close