[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