On 5/15/07, Michael Reece <[EMAIL PROTECTED]> wrote: >> but the generated query contains "ORDER BY t1.temp_asset_count DESC" >> and i can't seem to get the "t1." not added to the ORDER BY clause. >> >> i know i can resort to get_objects_from_sql, but are there any other >> suggestions?
You're already beyond what the Manager is currently able to do by using the undocumented group_by parameter... > this brings up another possibly useful feature, which would allow > something like > > discard_columns => ['temp_asset_count'] > > to keep me from having to set up an accessor for temp_asset_count, > which may never be used outside this sort_by clause. ...or just don't use MySQL 4 ;) On the sort_by thing, I'll probably add the ability to pass a reference to a scalar which will be taken as a literal. -John ------------------------------------------------------------------------- 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/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
