[Koha-cvs] CVS: koha/search.marc dictionary.pl,1.6.2.2,1.6.2.3

[Paul POULAIN]

Update of /cvsroot/koha/koha/search.marc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10444/search.marc

Modified Files:
      Tag: rel_2_2
	dictionary.pl 
Log Message:
special bugfix for HDL : when doing X+Y on 2 fields that can have a numeric value, you will get X+Y as result. What you wanted to do was concat(X,Y), to have 700+9 being 7009 and not 709 ;-)

Index: dictionary.pl
===================================================================
RCS file: /cvsroot/koha/koha/search.marc/dictionary.pl,v
retrieving revision 1.6.2.2
retrieving revision 1.6.2.3
diff -C2 -r1.6.2.2 -r1.6.2.3
*** dictionary.pl	7 Jun 2005 10:02:01 -0000	1.6.2.2
--- dictionary.pl	17 Jun 2005 15:53:35 -0000	1.6.2.3
***************
*** 106,110 ****
  	}
  	$listtags =~s/,$/)/;
! 	$strsth .= $listtags." and marc_word.tagsubfield=marc_subfield_table.tag+marc_subfield_table.subfieldcode group by subfieldvalue ";
  # 	warn "search in biblio : ".$strsth;
  	my $value = uc($search[0]);
--- 106,110 ----
  	}
  	$listtags =~s/,$/)/;
! 	$strsth .= $listtags." and marc_word.tagsubfield=concat(marc_subfield_table.tag,marc_subfield_table.subfieldcode) group by subfieldvalue ";
  # 	warn "search in biblio : ".$strsth;
  	my $value = uc($search[0]);