Re: [SQLObject] Re: orderBy RAND()?

Top Page
Author: Oleg Broytmann
Date:  
To: sqlobject-discuss
Subject: Re: [SQLObject] Re: orderBy RAND()?
On Thu, Oct 20, 2005 at 01:12:44PM -0500, Rick Flosi wrote:
> >Yes you can. order by random() works fine in PostgreSQL (8.0.3, 8.1 CVS)
> >here.
>
> The problem is doing it with SQLObject using orderBy=


   (untested)

from sqlobject.sqlbuilder import func
orderBy=func.RANDOM

   or may be

from sqlobject.sqlbuilder import SQLConstant
orderBy=SQLConstant("RANDOM()")

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@???
           Programmers don't die, they just GOSUB without RETURN.


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@???
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss