diff options
| -rw-r--r-- | extensions/ProdCompSearch/lib/WebService.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/extensions/ProdCompSearch/lib/WebService.pm b/extensions/ProdCompSearch/lib/WebService.pm index dea2e5e51..2e2592879 100644 --- a/extensions/ProdCompSearch/lib/WebService.pm +++ b/extensions/ProdCompSearch/lib/WebService.pm @@ -63,7 +63,8 @@ sub prod_comp_search { my $sql_word = $dbh->quote($word); trick_taint($sql_word); # note: CONCAT_WS is MySQL specific - my $field = "CONCAT_WS(' ', products.name, components.name, components.description)"; + my $field = "CONCAT_WS(' ', products.name, products.description, + components.name, components.description)"; push(@list, $dbh->sql_iposition($sql_word, $field) . " > 0"); } } |