From: Andy T. <an...@ha...> - 2003-06-18 19:59:25
|
I've got a table in my database which contains a date column. I'd like to be able to specify that rows are returned in date order, which can be done with the _defaultOrder special class variable. But - I'd like the records returned in reverse date order, which can be achieved in SQL with an order by clause like 'dateCol DESC'. I've tried this in my class definition but I get the following error; AssertionError: Strings in clauses are expected to be column identifiers. I got: 'price_date DESC' Is there a way to do this with SQLObject? Regards, Andy -- -------------------------------------------------------------------------------- From the desk of Andrew J Todd esq - http://www.halfcooked.com/ |