X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_main_ADV.cgi;h=17b17488b97acbf885672bd0de65fb61b164e630;hb=e68a2c760a79d6085f12be9add138067c9935074;hp=106b5965fe9fc480e30fcfd02df810fdace9dd04;hpb=e8d02908a0c85c4fcbaf7145ef00f0d3293e7311;p=freeside.git

diff --git a/httemplate/search/cust_main_ADV.cgi b/httemplate/search/cust_main_ADV.cgi
index 106b5965f..17b17488b 100755
--- a/httemplate/search/cust_main_ADV.cgi
+++ b/httemplate/search/cust_main_ADV.cgi
@@ -104,9 +104,9 @@ my $count_query = "SELECT COUNT(*) FROM cust_main $extra_sql";
 
 my $select;
 if ($dbh->{Driver}->{Name} eq 'Pg') {
-  $select = "*, array_to_string(array(select pkg from cust_pkg left join part_pkg using ( pkgpart ) where cust_main.custnum = cust_pkg.custnum $pkgwhere),',') as magic";
+  $select = "*, array_to_string(array(select pkg from cust_pkg left join part_pkg using ( pkgpart ) where cust_main.custnum = cust_pkg.custnum $pkgwhere),'|') as magic";
 }elsif ($dbh->{Driver}->{Name} =~ /^mysql/i) {
-  $select = "*, GROUP_CONCAT(pkg SEPARATOR ',') as magic";
+  $select = "*, GROUP_CONCAT(pkg SEPARATOR '|') as magic";
 }else{
   warn "warning: unknown database type ". $dbh->{Driver}->{Name}. 
        "omitting packing information from report.";
@@ -129,7 +129,7 @@ my (@extra_fields) = ();
 while($headercount) {
   unshift @extra_headers, "Package ". $headercount;
   unshift @extra_fields, eval q!sub {my $c = shift;
-                                     my @a = split ',', $c->magic;
+                                     my @a = split '\|', $c->magic;
                                      my $p = $a[!.--$headercount. q!];
                                      $p;
                                     };!;