X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fedit%2Frate.cgi;h=55fe319cfb577672b63e3561a7a77bfcd9d97c79;hb=b91bcdff200acb281c58c4ba5ef8482b335ecdbc;hp=72a04c339f4d4e5dab11d3bc864a9f6871fce4b2;hpb=3ce7691203a7737406bf2d4442f7fd84b81f847e;p=freeside.git
diff --git a/httemplate/edit/rate.cgi b/httemplate/edit/rate.cgi
index 72a04c339..55fe319cf 100644
--- a/httemplate/edit/rate.cgi
+++ b/httemplate/edit/rate.cgi
@@ -58,17 +58,21 @@ Rate plan
Granularity |
% foreach my $rate_region (
-% sort { lc($a->regionname) cmp lc($b->regionname) }
+% #sort { lc($a->regionname) cmp lc($b->regionname) }
% qsearch({
-% 'select' => 'DISTINCT ON ( regionnum ) rate_region.*',
% 'table' => 'rate_region',
% 'hashref' => {},
+% 'order_by' => 'ORDER BY lc(regionname)',
+%
+% #'select' => 'DISTINCT ON ( regionnum ) rate_region.*',
+% #...
% #'addl_from' => 'INNER JOIN rate_prefix USING ( regionnum )',
% #'extra_sql' => "WHERE countrycode != '1'",
%
% # 'ORDER BY regionname'
% # ERROR: SELECT DISTINCT ON expressions must
% # match initial ORDER BY expressions
+% # also, DISTINCT ON is a Pg-ism
% })
% ) {
% my $n = $rate_region->regionnum;