On 7/17/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > 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") > Thanks, I will try.
-- with kind regards ------------------------------------------------------------------------- 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
