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.select(orderBy="rate / 1+ EXTRACT(HOUR FROM AGE(CURRENT_TIMESTAMP,
updated))")
PS. I am sure you mean
rate / (1+ EXTRACT(HOUR FROM AGE(CURRENT_TIMESTAMP, updated)))
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
