fix small side-effect of mysql-compat change eliminating DISTINCT ON: map changing values of @where array

1 files changed, 4 insertions, 1 deletions

diff --git a/httemplate/search/cust_bill.html b/httemplate/search/cust_bill.html
index 7e76cf61f..f3105f83f 100755
--- a/httemplate/search/cust_bill.html
+++ b/httemplate/search/cust_bill.html
@@ -148,7 +148,10 @@ if ( $cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/ ) {
     #$orderby = 'ORDER BY cust_bill.custnum ASC, cust_bill._date DESC';
     #$count_query = "SELECT 'N/A', 'N/A', 'N/A'"; #XXXXXXX fix
     
-    my @newest_where = map { s/\bcust_bill\./newest_cust_bill./g; }
+    my @newest_where = map { my $x = $_;
+                             $x =~ s/\bcust_bill\./newest_cust_bill./g;
+                             $x;
+                          }
                            grep ! /^cust_main./, @where;
     my $newest_where = scalar(@newest_where)
                          ? ' AND '. join(' AND ', @newest_where)