On 7/16/07, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Mon, Jul 16, 2007 at 04:54:54PM +0800, ro wrote:
> > pages = MultipleJoin('Page', orderBy='name')
> >
> > I can get the pages from Space but the orderby is different the "order
> > by" in a normal SQL syntax.
>
> Add "?debug=1" to the DB URI and watch the queries SQLObject passes to
> the backend - any problems there?
>
> > The result of SqlObject give me is the uppercase before lowercase, for
> > example:
> > the "GetLastModifiedTime" before the "functions" in the result.
> >
> > But in normal SQL syntax, the "GetLastModifiedTime" must be after the
> > "functions"
>
> If you run a query with ORDER BY manually (without SQLObject at all)
> - does the backend return the rows in a proper order?
Yes, I have tried to run the SQL manually in server(MySQL), the result
set is right -- "f" in front of "G"
The SQL is "select * from page where space_id = 3 order by name asc"
--
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
