[ic] Problem with "Others who........" (resend in hope of an answer this time)

Eros Shop info at eros-shop.co.uk
Sat Mar 13 18:42:46 EST 2004


At 23:03 13/03/2004, you wrote:
>At 22:43 13/03/2004, you wrote:
>>On Sat, 13 Mar 2004, Eros Shop wrote:
>>
>> > After grep'ing for "50" in all interchange files, in the hope of finding
>> > some setting or value that may have some bearing on this mystery, I found
>> > the following in DbSearch.pm in /usr/lib/interchange/lib/Vend/
>> >
>> > my %Default = (
>> >          matches                 => 0,
>> >          mv_head_skip            => 0,
>> >          mv_index_delim          => "\t",
>> >          mv_matchlimit           => 50,
>> >          mv_min_string           => 1,
>> >          verbatim_columns        => 1,
>> > );
>> >
>> > Could the element "mv_matchlimit  => 50" be the magic number 50 that's
>> > haunting me?
>>
>>Almost certainly. That's not the first time someone has been bitten by
>>that default limit on the result set for Interchange-native searches. Try
>>changing your query call from this:
>>
>>     my $ary = $db->query( { sql => $query } );
>>
>>To this:
>>
>>     my $ary = $db->query( { sql => $query, mv_matchlimit => 0 } );
>>
>>Where 0 means no limit, IIRC. Or maybe "10000" or whatever.
>>
>>Jon
>
>Hi Jon,
>
>Thanks for the help....
>
>I've tried changing that line as suggested (using 0 and 100 as test 
>values) and i'm still stopping after 50 lines. Do I need to restart IC or 
>something for this to work or be applied?
>
>I'm getting the feeling that i can't set mv_matchlimit here?
>
>At worst I'll edit the DbSearch.pm file :)
>
>Thanks
>
>Mark
>

Jon,

The final solution for me turned out to be:

1: edit DbSearch.pm and setting a large mv_matchlimit of 1000000. A value 
of 0 did odd things to the UI nav buttons in that they disappeared!
2: restart IC
3: generate "others who" :)

Many thanks

Mark



Eros Shop
vwe internet ltd
PO BOX 1067
SLOUGH
SL1 7YA
UK

Shop - http://www.eros-shop.co.uk
EMail - info at eros-shop.co.uk
Tel - 0870 737 3369
Fax - 0870 737 4469




More information about the interchange-users mailing list