[ic] Actionmap 2 table problem

[Stefan Hornburg (Racke)]

On 06/27/2012 10:57 AM, IC wrote:
> Hi folks,
>
> I have an actionmap which *should* search 2 product tables for word $w1,
> however it only searches the last listed table, have I missed something?
>
>      $CGI->{mv_todo} = 'search';
>      $CGI->{mv_nextpage} = $Config->{SpecialPage}->{results};
>      $CGI->{mv_searchtype} = 'db';
>      $CGI->{mv_coordinate} = 'yes';
>      $CGI->{mv_substring_match} = 'yes';
>      $CGI->{mv_search_page} = 'results';
>
>      $CGI->{mv_search_file} = 'products';
>      $CGI->{mv_search_field} = "inactive\0description";
>      $CGI->{mv_searchspec} = "1\0$w1";
>      $CGI->{mv_column_op} = "ne\0rm";
>
>      $CGI->{mv_search_file} = 'products2';
>      $CGI->{mv_search_field} = "inactive\0description";
>      $CGI->{mv_searchspec} = "1\0$w1";
>      $CGI->{mv_column_op} = "ne\0rm";
>
>      $CGI->{mv_matchlimit} = '15';
>      $CGI->{mv_sort_field} = 'sale_price';
>      $CGI->{mv_sort_option} = 'n';
>

First of all I would rather do a native SQL query than fight
with Interchange's search parameters.

Second you just overwrite the settings in $CGI->{mv_search_file}
et al.

Please try to specify multiple tables in $CGI->{mv_search_file}
as follows:

$CGI->{mv_search_file} = 'products,products2';

Regards
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team