summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJonathan Prykop <jonathan@freeside.biz>2016-02-25 12:56:28 -0600
committerJonathan Prykop <jonathan@freeside.biz>2016-02-25 13:06:56 -0600
commit9075f8df5c274446dc42dd499413269effa183d5 (patch)
tree57cd15f525008d383c3f1cbb42d68011b8811fdb
parent5c98d3c21d07442fcf6d5a21aaef3e1fd5a206ca (diff)
RT#38597: OQM - svc Circuit use and setup [fixed case handling]
-rw-r--r--FS/FS/svc_circuit.pm6
1 files changed, 3 insertions, 3 deletions
diff --git a/FS/FS/svc_circuit.pm b/FS/FS/svc_circuit.pm
index 8ec0dadce..0d42bd96f 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) . ')';
}