On 7/17/07, Oleg Broytmann <phd@...> wrote:
> On Tue, Jul 17, 2007 at 11:59:05AM +0800, ro wrote:
> > On 7/16/07, Oleg Broytmann <phd@...> 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