On Tue, Jul 17, 2007 at 11:59:05AM +0800, ro wrote:
> On 7/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> >On Mon, Jul 16, 2007 at 05:07:33PM +0800, ro wrote:
> > About MultipleJoin: it doesn't use backend's ORDER BY, it sorts itself
> >in Python, hence the order "uppercase before lowercase". To use backend's
> >ORDER BY switch to SQLMultipleJoin. The difference is MultipleJoin draws
> >the rows as a list and sorts them, SQLMultipleJoin column constructs
> >a SelectResult instance that you can iterate over, and it runs the
> >corresponding SQL query.
>
> Thank you!
> OK, I think it's a problem with case-sensitive ,
> Do you know how to disable the case-sensitive in sqlobject's MultipleJoin?
There is no way for MultipleJoin because to sort in python it parses
SQL'ish orderBy in a very primitive way. For SQLMultipleJoin you can use
any SQL expression, for example, orderBy="lower(name)" or
orderBy=func.lower(MyTable.q.name) (don't forget
"from sqlobject.sqlbuilder import func")
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
