On May 15, 2007, at 11:32 AM, John Siracusa wrote: > 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...
true, maybe i should just change it to SQL.. > >> 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. i tried passing a \'' to see if that was already implemented, but it griped it was not an array-ref. ;) ------------------------------------------------------------------------- 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
