From: ivan <ivan>
Date: Thu, 14 Apr 2011 18:00:01 +0000 (+0000)
Subject: fix service searching, RT#12477
X-Git-Tag: freeside_2_3_0~394
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=f9e0909b36ecd985d95ee85551b7cd34a960bc7c

fix service searching, RT#12477
---

diff --git a/FS/FS/svc_hardware.pm b/FS/FS/svc_hardware.pm
index 5b81a9c2b..96a8e762b 100644
--- a/FS/FS/svc_hardware.pm
+++ b/FS/FS/svc_hardware.pm
@@ -112,7 +112,12 @@ sub search_sql {
     $hex =~ s/\W//g;
     push @where, 'svc_hardware.hw_addr LIKE \'%'.$hex.'%\'';
   }
-  '(' . join(' OR ', @where) . ')';
+
+  if ( @where ) {
+    '(' . join(' OR ', @where) . ')';
+  } else {
+    '1 = 0'; #false
+  }
 }
 
 sub label {