[ic] Actionmap 2 table problem

IC ic at tvcables.co.uk
Wed Jun 27 08:57:50 UTC 2012


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';

Thanks,
Andy.




More information about the interchange-users mailing list