On Feb 3, 2008 11:33 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Sun, Feb 03, 2008 at 09:04:20PM -0800, Barry Ferg wrote: > > Is there some way of reliably using the orderBy parameter with > > something other than a simple column, like a SQL function? > > Use SQLMultipleJoin instead of MultipleJoin. The difference is that > MultipleJoin returns a list (that is sorted by SQLObject in Python, hence > orderBy can be only a name of a column) where SQLMultipleJoin returns > whatever .select() returns (an instance of SelectResult class) which passes > orderBy to SQL. > > Oleg.
Thanks Oleg, that works! I don't think the documentation had anything to say about the way that relates to orderBy - I suppose I should spend more quality time with the source. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
