From 88e392c15739a6d0b2ab1234b8b556d1ab6dd1de Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 5 Dec 2007 20:50:21 +0000
Subject: [PATCH] doh, order_by does have to include ORDER BY!

---
 httemplate/elements/tr-select-reason.html | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/httemplate/elements/tr-select-reason.html b/httemplate/elements/tr-select-reason.html
index 9684f37a2..42cd3d5bb 100755
--- a/httemplate/elements/tr-select-reason.html
+++ b/httemplate/elements/tr-select-reason.html
@@ -121,7 +121,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;
-- 
2.20.1