From 37422d668cdd441db06007368b2c1858ad45c0b3 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 2 Apr 2008 17:07:25 +0000 Subject: [PATCH 1/1] get the text value, then transform git-svn-id: svn://svn.open-ils.org/ILS/trunk@9192 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm index c12bab96a8..f5307ef425 100644 --- a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm +++ b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm @@ -949,12 +949,14 @@ sub toSQL { $sql .= " NOT BETWEEN ". join(" AND ", map { $_->toSQL } @$val); } elsif (lc($op) eq 'like') { $val = $$val[0] if (ref($val) eq 'ARRAY'); + $val = $val->toSQL; $val =~ s/^'(.*)'$/$1/o; $val =~ s/%/\\\\%/o; $val =~ s/_/\\\\_/o; $sql .= " LIKE '\%$val\%'"; } elsif (lc($op) eq 'ilike') { $val = $$val[0] if (ref($val) eq 'ARRAY'); + $val = $val->toSQL; $val =~ s/^'(.*)'$/$1/o; $val =~ s/%/\\\\%/o; $val =~ s/_/\\\\_/o; -- 2.43.2