On Fri, Dec 24, 2010 at 10:44 AM, Oleg Broytman <p...@phdru.name> wrote: > Oops, columns in Select cannot be strings - to allow strings in > queries. > > Use sqlbuilder.Select(sqlbuilder.func.MAX(sqlbuilder.const.serial) > > from sqlobject.sqlbuilder import Select, func, const > Select(func.MAX(const.serial) > > looks better for my eyes.
Oleg, once again, thank you. I was looking for the MAX function and was unable to find it. Const is interesting as well, it takes the provided attr and transforms it to verbatim in the resulting SQL, neat. The above works perfectly! ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
