diff options
| author | Mark Wells <mark@freeside.biz> | 2013-05-07 15:16:11 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-05-07 15:16:11 -0700 |
| commit | 0dfdc3e5dc012c1a2640ac2af22b1488cdfbd083 (patch) | |
| tree | 215ca5ce6d27ffcf65eaa64b6e24e1f62405750a /FS/FS/cust_svc.pm | |
| parent | c6fa106e14a3bff641ca9f4f8a95c2749c53ba95 (diff) | |
fix smart search for all-numeric strings
Diffstat (limited to 'FS/FS/cust_svc.pm')
| -rw-r--r-- | FS/FS/cust_svc.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_svc.pm b/FS/FS/cust_svc.pm index cab80a8..6274107 100644 --- a/FS/FS/cust_svc.pm +++ b/FS/FS/cust_svc.pm @@ -870,7 +870,7 @@ sub smart_search_param { FS::part_svc->svc_tables; if ( $string =~ /^(\d+)$/ ) { - unshift @or, "SELECT cust_svc.svcnum, NULL FROM cust_svc WHERE agent_svcid = $1"; + unshift @or, "SELECT cust_svc.svcnum, NULL as svcdb FROM cust_svc WHERE agent_svcid = $1"; } my $addl_from = " RIGHT JOIN (\n" . join("\nUNION\n", @or) . "\n) AS svc_all ". |