[mv] [BUG] Interchange Search Problem

[Stefan Hornburg <racke@linuxia.de>]

******    message to minivend-users from Stefan Hornburg <racke@linuxia.de>     ******


There is a problem with the MiniVend code in IC latest with database
records containing \t in their fields. This is at least possible
with SQL databases. The code portion(s) which is found in DbSearch.pm
looks like that:

		elsif(defined $limit_sub) {
#::logDebug("f and limit, dbref=$dbref");
			while($_ = join "\t", $dbref->each_nokey($qual || undef) ) {
				next unless &$f();
				next unless &$limit_sub($_);
				push @out, &$return_sub($_);
			}
		}

Any tabs in columns let shows the wrong fields up in limit_sub.
How can this be fixed ? I have no suggestion yet, only a workaround
for DBI.pm:

	for (my $i; $i < @$return; $i++) {
	  $$return[$i] =~ s/\t/ /g;
	}

Insert it at the end of each_nokey.

BTW: Why does MV sorts the records out itself. For performance and
debugging it would be better to push this task to the SQL engine.

Ciao
        Racke

-- 
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Coding from hell and back <--- 
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list