2007/8/20, Oleg Broytmann <[EMAIL PROTECTED]>: > 1 contradicts 2 because SQLBuilder doesn't perform any conversion. > Column objects perform conversions. So, either SQLObject with conversions > or SQLBuilder with raw data,
I see. > > for row in connection.queryAll( 'SELECT DISTINCT date(entry.begin) > > SELECT DISTINCT in SQLBuilder is implemented in the trunk by Luke > Opperman. Wait until it will be released as SQLObject 0.10, or use the code > from the trunk, it is stable enough to be useable. > > from sqlobject.sqlbuilder import Select, func > for row in conn.queryAll(conn.sqlrepr( > Select(func.date(Entry.q.begin), distinct=True) > )) Ok. And is there a way to put the 'query' variable, which is of __class__ sqlobject.sqlbuilder.SQLOp, from my original code into the SQLBuilder version? The query is already constructed elsewhere and passed around in my program. Kind regards, Markus ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
