X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fsvc_circuit.pm;h=13d84846e17aaf08b1aeff17b0a837554ccccc20;hp=1a42efadd944981708e0ac5aaa861a340d0cf6f0;hb=ff27c3f36240aee48ed50153dd5d8fe3ac3f2443;hpb=f32ac83068c6211f829f1688a1a9cdec71bc6ec7 diff --git a/FS/FS/svc_circuit.pm b/FS/FS/svc_circuit.pm index 1a42efadd..13d84846e 100644 --- a/FS/FS/svc_circuit.pm +++ b/FS/FS/svc_circuit.pm @@ -221,9 +221,9 @@ sub label { sub search_sql { my ($class, $string) = @_; my @where = (); - push @where, 'LOWER(svc_circuit.circuit_id) = ' . dbh->quote($string); - push @where, 'LOWER(circuit_provider.provider) = ' . dbh->quote($string); - push @where, 'LOWER(circuit_type.typename) = ' . dbh->quote($string); + push @where, 'LOWER(svc_circuit.circuit_id) = LOWER(' . dbh->quote($string) . ')'; + push @where, 'LOWER(circuit_provider.provider) = LOWER(' . dbh->quote($string) . ')'; + push @where, 'LOWER(circuit_type.typename) = LOWER(' . dbh->quote($string) . ')'; '(' . join(' OR ', @where) . ')'; }