From: ivan <ivan>
Date: Wed, 5 Dec 2007 20:50:20 +0000 (+0000)
Subject: doh, order_by does have to include ORDER BY!
X-Git-Tag: TRIXBOX_2_6~192
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=4ea9774ab600337021720675c1633fbf59826fed

doh, order_by does have to include ORDER BY!
---

diff --git a/httemplate/elements/tr-select-reason.html b/httemplate/elements/tr-select-reason.html
index 04a5c4582..b57f78a1e 100755
--- a/httemplate/elements/tr-select-reason.html
+++ b/httemplate/elements/tr-select-reason.html
@@ -141,7 +141,7 @@ my @reasons = qsearch({
   extra_sql => $extra_sql,
   addl_from => 'LEFT JOIN reason_type '.
                ' ON reason_type.typenum = reason.reason_type',
-  order_by  => 'reason_type.type ASC, reason.reason ASC',
+  order_by  => 'ORDER BY reason_type.type ASC, reason.reason ASC',
 });
 
 my $curuser = $FS::CurrentUser::CurrentUser;