From b327a081e5f6223cf4c46e93a959cc7bbc81710a Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 29 Oct 2007 11:34:21 +0000 Subject: [PATCH] yup, mysql-ing me harder --- httemplate/edit/rate.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/httemplate/edit/rate.cgi b/httemplate/edit/rate.cgi index 55fe319cf..c44364da9 100644 --- a/httemplate/edit/rate.cgi +++ b/httemplate/edit/rate.cgi @@ -62,7 +62,7 @@ Rate plan % qsearch({ % 'table' => 'rate_region', % 'hashref' => {}, -% 'order_by' => 'ORDER BY lc(regionname)', +% 'order_by' => 'ORDER BY LOWER(regionname)', % % #'select' => 'DISTINCT ON ( regionnum ) rate_region.*', % #... -- 2.20.1