Groovy SQL在动态选择语句中忽略order by子句

I am using Groovy SQL in a Grails application to query against a database that isn't hooked up as the application's datasource. By default for the page, the SQL select statement doesn't contain an order by clause. If the user clicks on one of the tags, I want to dynamically change the query to sort on the specified column in the specified direction. When I attempt to add the order by clause to the select statement, I get a (caught) SQLException that says that my query was improperly ended.I am using Groovy SQL in a Grails application t