projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add dsl, circuit and fiber services to email and RT ticket exports, RT#84345
[freeside.git]
/
httemplate
/
search
/
cust_pkg_summary.cgi
diff --git
a/httemplate/search/cust_pkg_summary.cgi
b/httemplate/search/cust_pkg_summary.cgi
index
c0eb699
..
76ca895
100644
(file)
--- a/
httemplate/search/cust_pkg_summary.cgi
+++ b/
httemplate/search/cust_pkg_summary.cgi
@@
-56,7
+56,8
@@
foreach my $column (keys %conds) {
my $count_query = $h_search->{count_query};
# push a select expression for the total packages with pkgpart=main.pkgpart
my $count_query = $h_search->{count_query};
# push a select expression for the total packages with pkgpart=main.pkgpart
- push @select, "($count_query AND h_cust_pkg.pkgpart = main.pkgpart) AS $column";
+ # (have to quote $column, otherwise mysql thinks before/after are keywords)
+ push @select, "($count_query AND h_cust_pkg.pkgpart = main.pkgpart) AS \"$column\"";
# and query the total packages with pkgpart=any of the main.pkgparts
my $total = FS::Record->scalar_sql($count_query .
# and query the total packages with pkgpart=any of the main.pkgparts
my $total = FS::Record->scalar_sql($count_query .