[ic] Get ActionMap to search 2 fields?

[Peter]

On 09/23/2009 03:27 AM, IC wrote:
> Sorry if this is a duplicate, it appeared the first one never made the list.
> 
> Hi Folks,
> 
> I am trying to get an ActionMap to search 2 fields (category and category2)
> of the products table for the value of $category, I currently have:-
> 
> $CGI->{mv_search_field} = "inactive\0prod_group\0category2,category";
> $CGI->{mv_searchspec} = "1\0$prodgroup\0$category"; $CGI->{mv_column_op} =
> "ne\0rm\0rm";
> 
> This doesn't work, is it the comma that is the problem, I tried escaping it
> as well \, ??
> 
> Performing a scan using sf=category,category2 in a browser bar seems to work
> ok so how do I get this into the actionmap?

The problem is you're using a coordinated and search for inactive and
prod_group and trying to combine it with an or search for category2 or
category.  Interchange is not able to do this the way you want.


Peter