X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fcust_pkg.pm;h=27c25daa96a6c6491eef52ccbf1f4a4302d0e26d;hb=c7ad63f42570c80ba01e00326e62a8ef66ba86c3;hp=1cca10bc4d877380301d063ac849927562c52030;hpb=cfcc4c14a40c84d1603c707066e7644aefef5690;p=freeside.git diff --git a/FS/FS/cust_pkg.pm b/FS/FS/cust_pkg.pm index 1cca10bc4..27c25daa9 100644 --- a/FS/FS/cust_pkg.pm +++ b/FS/FS/cust_pkg.pm @@ -3682,7 +3682,7 @@ sub _location_sql_where { # ( $table.${prefix}city = ? $or_empty_city $ornull ) " - ( $table.${prefix}district = ? OR ? = '' OR CAST(? AS text) IS NULL ) + ( $table.district = ? OR ? = '' OR CAST(? AS text) IS NULL ) AND ( $table.${prefix}city = ? OR ? = '' OR CAST(? AS text) IS NULL ) AND ( $table.${prefix}county = ? $or_empty_county $ornull ) AND ( $table.${prefix}state = ? $or_empty_state $ornull )