From dec6e3b80f40c249207642d4fa6e9feca7a5a8c9 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 5 May 2006 00:42:42 +0000 Subject: fixed HAVING/ORDER BY order, 0.1.7 prep --- lib/sqlalchemy/ansisql.py | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'lib/sqlalchemy/ansisql.py') diff --git a/lib/sqlalchemy/ansisql.py b/lib/sqlalchemy/ansisql.py index a344e017c..602da58ee 100644 --- a/lib/sqlalchemy/ansisql.py +++ b/lib/sqlalchemy/ansisql.py @@ -371,14 +371,14 @@ class ANSICompiler(sql.Compiled): if group_by: text += " GROUP BY " + group_by - order_by = self.get_str(select.order_by_clause) - if order_by: - text += " ORDER BY " + order_by - if select.having is not None: t = self.get_str(select.having) if t: text += " \nHAVING " + t + + order_by = self.get_str(select.order_by_clause) + if order_by: + text += " ORDER BY " + order_by text += self.visit_select_postclauses(select) -- cgit v1.2.1