Re: [SQLObject] Expression in orderBy

2007-03-14 Thread Oleg Broytmann
On Wed, Mar 14, 2007 at 04:58:50PM -0400, Fred C wrote: > I have try that before and I got this error > > AssertionError: Strings in clauses are expected to be column > identifiers. I got: 'rate / (1+ EXTRACT(HOUR FROM AGE > (CURRENT_TIMESTAMP, updated)))' Try this: from sqlobject.sqlbuil

Re: [SQLObject] Expression in orderBy

2007-03-14 Thread Fred C
On Mar 14, 2007, at 4:48 PM, Oleg Broytmann wrote: > On Wed, Mar 14, 2007 at 04:36:02PM -0400, Fred C wrote: >> How can you translate something like that into something suitable for >> the parameter orderBy ? >> >> items = Item.select(orderBy=()) >> >> rate / 1+ EXTRACT(HOUR FROM AGE(CURRENT_TIME

Re: [SQLObject] Expression in orderBy

2007-03-14 Thread Oleg Broytmann
On Wed, Mar 14, 2007 at 04:36:02PM -0400, Fred C wrote: > How can you translate something like that into something suitable for > the parameter orderBy ? > > items = Item.select(orderBy=()) > > rate / 1+ EXTRACT(HOUR FROM AGE(CURRENT_TIMESTAMP, updated)) You can pass a string: items = Item

[SQLObject] Expression in orderBy

2007-03-14 Thread Fred C
Hi How can you translate something like that into something suitable for the parameter orderBy ? items = Item.select(orderBy=()) rate / 1+ EXTRACT(HOUR FROM AGE(CURRENT_TIMESTAMP, updated)) Thanks for your help. -fred