fix small side-effect of mysql-compat change eliminating DISTINCT ON: map changing...
authorivan <ivan>
Tue, 27 Nov 2007 23:47:07 +0000 (23:47 +0000)
committerivan <ivan>
Tue, 27 Nov 2007 23:47:07 +0000 (23:47 +0000)
httemplate/search/cust_bill.html

index be7406e..e3ea8de 100755 (executable)
@@ -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)