From be5f0ff96590b92429464363365936db9edf8be2 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Tue, 27 Nov 2007 23:47:20 +0000
Subject: [PATCH] fix small side-effect of mysql-compat change eliminating
 DISTINCT ON: map changing values of @where array

---
 httemplate/search/cust_bill.html | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

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)
-- 
2.20.1